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