APPS.GME_CLOSE_BATCH_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 685: FROM gme_batch_step_dependencies d

681:
682: CURSOR cur_get_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
683: IS
684: SELECT d.dep_step_id
685: FROM gme_batch_step_dependencies d
686: WHERE d.batch_id = v_batch_id
687: START WITH ( (d.batch_id = v_batch_id)
688: AND ( (v_batchstep_id IS NULL)
689: OR (batchstep_id = v_batchstep_id) ) )

Line 707: FROM gme_batch_step_dependencies

703: SELECT *
704: FROM gme_batch_steps s
705: WHERE s.batch_id = v_batch_id
706: AND s.batchstep_id NOT IN (SELECT dep_step_id
707: FROM gme_batch_step_dependencies
708: WHERE batch_id = v_batch_id)
709: ORDER BY batchstep_no;
710:
711: /* Buffer records for database read.