| Operation Details |  |
| Description: | Search the task id where queued in the batch process. |
| Sterotype: | nsmulti |
| SQL | |
SELECT
t.taskID INTO :taskID from Task t
INNER JOIN
GenericBatchProcessInput gbp
ON t.taskID=gbp.recordID
WHERE t.reservedBy=:userName
AND gbp.batchProcessName = 'BP_TASK_FW'
AND gbp.resultStatus IN ('BPRS_IN_PR', 'BPRS_N_PRO')
|