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