APPS.GME_COMMON_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 1500: FROM gme_batch_step_items

1496:
1497: CURSOR cur_get_associated_step (v_material_detail_id NUMBER)
1498: IS
1499: SELECT batchstep_id
1500: FROM gme_batch_step_items
1501: WHERE material_detail_id = v_material_detail_id;
1502:
1503: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
1504: IS

Line 3421: FROM gme_batch_step_items

3417: SELECT COUNT (1)
3418: INTO l_assoc_count
3419: FROM DUAL
3420: WHERE EXISTS (SELECT 1
3421: FROM gme_batch_step_items
3422: WHERE material_detail_id = p_material_detail_id);
3423:
3424: IF l_assoc_count = 0 THEN
3425: l_is_assoc := FALSE;

Line 3459: FROM gme_batch_step_items a, gme_batch_steps s

3455:
3456: CURSOR get_assoc_step (v_material_detail_id IN NUMBER)
3457: IS
3458: SELECT a.batchstep_id, s.step_status
3459: FROM gme_batch_step_items a, gme_batch_steps s
3460: WHERE a.material_detail_id = v_material_detail_id
3461: AND a.batchstep_id = s.batchstep_id
3462: AND a.batch_id = s.batch_id;
3463: BEGIN

Line 4830: FROM gme_batch_step_items

4826: SELECT COUNT (1)
4827: INTO l_dep_count
4828: FROM DUAL
4829: WHERE EXISTS (SELECT 1
4830: FROM gme_batch_step_items
4831: WHERE material_detail_id = p_line_id);
4832:
4833: IF l_dep_count = 0 THEN
4834: l_is_auto := 0;

Line 5355: FROM gme_batch_step_items

5351:
5352: CURSOR cur_get_associated_step (v_material_detail_id NUMBER)
5353: IS
5354: SELECT batchstep_id
5355: FROM gme_batch_step_items
5356: WHERE material_detail_id = v_material_detail_id;
5357:
5358: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
5359: IS