DBA Data[Home] [Help]

APPS.GMO_CBR_GRP dependencies on GME_BATCH_HEADER

Line 766: FROM GME_BATCH_HEADER

762: l_batch_id := l_event_key;
763: l_message_prod := 'GME';
764: l_message_token:= 'GME_PSIG_BATCH_LABEL';
765: SELECT PLAN_START_DATE into l_plan_start_date
766: FROM GME_BATCH_HEADER
767: WHERE batch_id = l_batch_id;
768: --
769: -- If event is batch creation event then store
770: -- e-record XML into CBR XML

Line 1002: FROM GME_BATCH_HEADER_VW

998: l_step_label VARCHAR2(400);
999: l_step_user_val VARCHAR2(400);
1000: CURSOR Get_BATCH_DETAILS IS
1001: SELECT BATCH_ID,BATCH_NO,PLANT_CODE,PLAN_START_DATE,PLAN_CMPLT_DATE
1002: FROM GME_BATCH_HEADER_VW
1003: WHERE batch_id = P_BATCH_ID;
1004: CURSOR GET_STEP_DETAILS IS
1005: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_NO,OPERATION_NO,PLAN_START_DATE,PLAN_CMPLT_DATE
1006: FROM gme_batch_steps_v