APPS.GME_REOPEN_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 162: FROM gme_batch_step_dependencies gbsd, gme_batch_steps gbs

158:
159: CURSOR cur_fetch_dep_steps (l_batchstep_id IN NUMBER, l_batch_id NUMBER)
160: IS
161: SELECT COUNT (*)
162: FROM gme_batch_step_dependencies gbsd, gme_batch_steps gbs
163: WHERE gbs.batchstep_id = gbsd.batchstep_id
164: AND gbsd.dep_step_id = l_batchstep_id
165: AND gbs.batch_id = l_batch_id
166: AND gbsd.batch_id = gbs.batch_id