APPS.GMO_CBR_GRP dependencies on GME_BATCH_STEP_RESOURCES

Line 860: FROM GME_BATCH_STEP_RESOURCES

856: l_message_token:= 'GME_PSIG_BATCH_STEP_RSRC_LABEL';
857: IF l_event_name = 'oracle.apps.gme.resource.added'
858: THEN
859: SELECT PLAN_START_DATE into l_plan_start_date
860: FROM GME_BATCH_STEP_RESOURCES
861: WHERE batch_id = l_batch_id
862: AND BATCHSTEP_RESOURCE_ID = l_batch_rsrc_id;
863: END IF;
864: ELSIF l_event_name in ('oracle.apps.gme.activity.added'

Line 1445: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES

1441: SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
1442: FROM gmo_material_undispenses
1443: WHERE undispense_id = p_entity_key;
1444: CURSOR get_resource_details IS
1445: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES
1446: where BATCHSTEP_RESOURCE_ID = p_entity_key;
1447: BEGIN
1448: delete GMO_BATCH_PROGRESSION
1449: where event = P_EVENT_NAME