APPS.GME_CLOSE_BATCH_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 789: FROM gme_batch_step_dependencies d

785:
786: CURSOR cur_get_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
787: IS
788: SELECT d.dep_step_id
789: FROM gme_batch_step_dependencies d
790: WHERE d.batch_id = v_batch_id
791: START WITH ( (d.batch_id = v_batch_id)
792: AND ( (v_batchstep_id IS NULL)
793: OR (batchstep_id = v_batchstep_id) ) )

Line 811: FROM gme_batch_step_dependencies

807: SELECT *
808: FROM gme_batch_steps s
809: WHERE s.batch_id = v_batch_id
810: AND s.batchstep_id NOT IN (SELECT dep_step_id
811: FROM gme_batch_step_dependencies
812: WHERE batch_id = v_batch_id)
813: ORDER BY batchstep_no;
814:
815: /* Buffer records for database read.