Operation Details
Description: Search the assigned 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 IS NULL  
AND gbp.batchProcessName = 'BP_ATK_FW'    
AND gbp.resultStatus IN ('BPRS_IN_PR', 'BPRS_N_PRO')