APPS.GME_COMMON_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 1403: FROM gme_batch_step_items

1399:
1400: CURSOR cur_get_associated_step (v_material_detail_id NUMBER)
1401: IS
1402: SELECT batchstep_id
1403: FROM gme_batch_step_items
1404: WHERE material_detail_id = v_material_detail_id;
1405:
1406: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
1407: IS

Line 3162: FROM gme_batch_step_items

3158: SELECT COUNT (1)
3159: INTO l_assoc_count
3160: FROM DUAL
3161: WHERE EXISTS (SELECT 1
3162: FROM gme_batch_step_items
3163: WHERE material_detail_id = p_material_detail_id);
3164:
3165: IF l_assoc_count = 0 THEN
3166: l_is_assoc := FALSE;

Line 3200: FROM gme_batch_step_items a, gme_batch_steps s

3196:
3197: CURSOR get_assoc_step (v_material_detail_id IN NUMBER)
3198: IS
3199: SELECT a.batchstep_id, s.step_status
3200: FROM gme_batch_step_items a, gme_batch_steps s
3201: WHERE a.material_detail_id = v_material_detail_id
3202: AND a.batchstep_id = s.batchstep_id
3203: AND a.batch_id = s.batch_id;
3204: BEGIN

Line 4571: FROM gme_batch_step_items

4567: SELECT COUNT (1)
4568: INTO l_dep_count
4569: FROM DUAL
4570: WHERE EXISTS (SELECT 1
4571: FROM gme_batch_step_items
4572: WHERE material_detail_id = p_line_id);
4573:
4574: IF l_dep_count = 0 THEN
4575: l_is_auto := 0;

Line 5087: FROM gme_batch_step_items

5083:
5084: CURSOR cur_get_associated_step (v_material_detail_id NUMBER)
5085: IS
5086: SELECT batchstep_id
5087: FROM gme_batch_step_items
5088: WHERE material_detail_id = v_material_detail_id;
5089:
5090: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
5091: IS