Operation Details |
Description: | Gets Training Credit records count for the given Training ID, Provider Category and Provider Type. |
Sterotype: | ns |
SQL |
SELECT COUNT(TrainingCredit.trainingCreditID) INTO :count FROM TrainingCredit WHERE TrainingCredit.trainingID = :trainingID AND TrainingCredit.providerCategory = :providerCategory AND TrainingCredit.providerType = :providerType AND TrainingCredit.recordStatus = :recordStatus |