DBA Data[Home] [Help]

APPS.GMO_CBR_GRP dependencies on GME_BATCH_HEADER

Line 792: FROM GME_BATCH_HEADER

788: l_batch_id := l_event_key;
789: l_message_prod := 'GME';
790: l_message_token:= 'GME_PSIG_BATCH_LABEL';
791: SELECT PLAN_START_DATE into l_plan_start_date
792: FROM GME_BATCH_HEADER
793: WHERE batch_id = l_batch_id;
794: --
795: -- If event is batch creation event then store
796: -- e-record XML into CBR XML

Line 1066: FROM GME_BATCH_HEADER_VW

1062: l_step_label VARCHAR2(400);
1063: l_step_user_val VARCHAR2(400);
1064: CURSOR Get_BATCH_DETAILS IS
1065: SELECT BATCH_ID,BATCH_NO,PLANT_CODE,PLAN_START_DATE,PLAN_CMPLT_DATE
1066: FROM GME_BATCH_HEADER_VW
1067: WHERE batch_id = P_BATCH_ID;
1068: CURSOR GET_STEP_DETAILS IS
1069: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_NO,OPERATION_NO,PLAN_START_DATE,PLAN_CMPLT_DATE
1070: FROM gme_batch_steps_v