APPS.GME_RELEASE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 26: FROM gme_batch_steps s, gme_batch_step_items item

22: AND line_type = gme_common_pvt.g_line_type_ing;
23:
24: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
25: SELECT s.*
26: FROM gme_batch_steps s, gme_batch_step_items item
27: WHERE s.batchstep_id = item.batchstep_id
28: AND item.material_detail_id = v_matl_dtl_id;
29:
30: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';

Line 32: l_step_rec gme_batch_steps%ROWTYPE;

28: AND item.material_detail_id = v_matl_dtl_id;
29:
30: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
31:
32: l_step_rec gme_batch_steps%ROWTYPE;
33: l_matl_dtl_tab gme_common_pvt.material_details_tab;
34: l_matl_dtl_rec gme_material_details%ROWTYPE;
35: l_release_type NUMBER;
36: l_phantom_batch_rec gme_batch_header%ROWTYPE;

Line 1531: FROM gme_batch_steps s, gme_batch_step_items item

1527: AND phantom_type <> 0;
1528:
1529: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
1530: SELECT s.batchstep_id
1531: FROM gme_batch_steps s, gme_batch_step_items item
1532: WHERE s.batchstep_id = item.batchstep_id
1533: AND item.material_detail_id = v_matl_dtl_id;
1534:
1535: l_api_name CONSTANT VARCHAR2 (30) := 'check_unexploded_phantom';