| Operation Details |  |
| Description: | Count the record id where queued in the batch process. |
| Sterotype: | ns |
| SQL | |
SELECT
COUNT(*) INTO :numberOfRecords
FROM GenericBatchProcessInput gbp
WHERE
gbp.batchProcessName = :batchProcessName
AND gbp.resultStatus IN ('BPRS_IN_PR', 'BPRS_N_PRO')
AND gbp.recordID = :recordID
|