APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 101: FROM gme_material_details m, gme_batch_step_items i

97: CURSOR cur_get_phant (v_batch_id NUMBER)
98: IS
99: SELECT phantom_id, m.material_detail_id, release_type, line_type
100: ,i.batchstep_id
101: FROM gme_material_details m, gme_batch_step_items i
102: WHERE m.batch_id = v_batch_id
103: AND NVL (phantom_id, 0) > 0
104: AND m.batch_id = i.batch_id(+)
105: AND m.material_detail_id = i.material_detail_id(+);

Line 907: FROM gme_batch_step_items

903: INTO l_start_date, l_cmplt_date
904: FROM gme_batch_steps
905: WHERE batch_id = x_batch_header_rec.batch_id
906: AND batchstep_id = (SELECT batchstep_id
907: FROM gme_batch_step_items
908: WHERE batch_id = x_batch_header_rec.batch_id
909: AND material_detail_id = l_material_detail_ids(i));
910:
911: