APPS.GME_BATCHSTEP_RSRC_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 92: FROM gme_batch_step_activities

88: ,v_activity VARCHAR2
89: ,v_batch_id NUMBER)
90: IS
91: SELECT batchstep_activity_id
92: FROM gme_batch_step_activities
93: WHERE batchstep_id = v_step_id
94: AND batch_id = v_batch_id
95: AND activity = v_activity;
96:

Line 347: FROM gme_batch_steps a, gme_batch_step_activities b

343:
344: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
345: IS
346: SELECT a.step_status, a.batch_id, a.step_qty_um
347: FROM gme_batch_steps a, gme_batch_step_activities b
348: WHERE b.batchstep_activity_id = v_act_id
349: AND a.batch_id = b.batch_id
350: AND a.batchstep_id = b.batchstep_id;
351:

Line 359: FROM gme_batch_step_activities

355: ,1, plan_activity_factor
356: ,actual_activity_factor)
357: ,plan_start_date, plan_cmplt_date, actual_start_date
358: ,actual_cmplt_date
359: FROM gme_batch_step_activities
360: WHERE batchstep_activity_id = v_activity_id;
361:
362: CURSOR cur_get_activity_detail (v_activity_id NUMBER)
363: IS

Line 365: FROM gme_batch_step_activities

361:
362: CURSOR cur_get_activity_detail (v_activity_id NUMBER)
363: IS
364: SELECT plan_start_date, plan_cmplt_date
365: FROM gme_batch_step_activities
366: WHERE batchstep_activity_id = v_activity_id;
367:
368: CURSOR cur_get_batch_asqc (v_batch_id NUMBER)
369: IS

Line 2106: FROM gme_batch_step_activities

2102: CURSOR cur_get_act_dates
2103: IS
2104: SELECT plan_start_date, plan_cmplt_date, actual_start_date
2105: ,actual_cmplt_date
2106: FROM gme_batch_step_activities
2107: WHERE batchstep_activity_id = p_batchstep_activity_id;
2108: BEGIN
2109: IF g_debug <= gme_debug.g_log_procedure THEN
2110: gme_debug.put_line ('Entering api ' ||