APPS.GMO_CBR_GRP dependencies on GME_BATCH_STEP_RESOURCES

Line 834: FROM GME_BATCH_STEP_RESOURCES

830: l_message_token:= 'GME_PSIG_BATCH_STEP_RSRC_LABEL';
831: IF l_event_name = 'oracle.apps.gme.resource.added'
832: THEN
833: SELECT PLAN_START_DATE into l_plan_start_date
834: FROM GME_BATCH_STEP_RESOURCES
835: WHERE batch_id = l_batch_id
836: AND BATCHSTEP_RESOURCE_ID = l_batch_rsrc_id;
837: END IF;
838: ELSIF l_event_name in ('oracle.apps.gme.activity.added'

Line 1381: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES

1377: SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
1378: FROM gmo_material_undispenses
1379: WHERE undispense_id = p_entity_key;
1380: CURSOR get_resource_details IS
1381: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES
1382: where BATCHSTEP_RESOURCE_ID = p_entity_key;
1383: BEGIN
1384: delete GMO_BATCH_PROGRESSION
1385: where event = P_EVENT_NAME