DBA Data[Home] [Help]

APPS.GMDRTVAL_PUB dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 409: FROM gme_batch_step_dependencies

405: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;
406:
407: CURSOR Cur_get_batch_steps IS
408: SELECT distinct batchstep_id
409: FROM gme_batch_step_dependencies
410: WHERE batch_id = pparent_key;
411: X_batch_step_rec Cur_get_batch_steps%ROWTYPE;
412:
413: CURSOR Cur_check_rout_step_depen (V_routingstep_no NUMBER) IS

Line 422: FROM gme_batch_step_dependencies

418: AND (PRIOR routing_id = routing_id);
419:
420: CURSOR Cur_check_batch_step_depen (V_batchstep_id NUMBER) IS
421: SELECT max(batchstep_id)
422: FROM gme_batch_step_dependencies
423: START WITH batch_id = pparent_key AND
424: batchstep_id = V_batchstep_id
425: CONNECT BY (PRIOR dep_step_id = batchstep_id)
426: AND (PRIOR batch_id = batch_id);