APPS.OPI_EDW_OPM_PRD_PKG dependencies on PS_SCHD_HDR

Line 251: SCHEDULE_VI ps_schd_hdr.schedule%type;

247: Count1_V INTEGER := 0;
248: Count2_V INTEGER := 0;
249: batch_time_v INTEGER := 0;
250: PLANT_CODE_V1 PM_BTCH_HDR.PLANT_CODE%type;
251: SCHEDULE_VI ps_schd_hdr.schedule%type;
252: SHIFT_START_V INTEGER := 0;
253: SHIFT_END_V INTEGER := 0;
254: SHIFT_DURATION_V INTEGER;
255: start_sec INTEGER;

Line 263: SCHEDULE_V PS_SCHD_HDR.SCHEDULE%TYPE,

259: batch_days_v NUMBER;
260: Batch_day_V1 DATE;
261:
262: CURSOR shop_cal_CUR(
263: SCHEDULE_V PS_SCHD_HDR.SCHEDULE%TYPE,
264: PLANT_CODE_V PM_BTCH_HDR.PLANT_CODE%type,
265: Batch_day_V DATE )
266: IS
267: SELECT shift_start,shift_duration

Line 268: FROM ps_schd_dtl sd, ps_schd_hdr sh,

264: PLANT_CODE_V PM_BTCH_HDR.PLANT_CODE%type,
265: Batch_day_V DATE )
266: IS
267: SELECT shift_start,shift_duration
268: FROM ps_schd_dtl sd, ps_schd_hdr sh,
269: mr_shcl_dtl sc, mr_shdy_dtl sl
270: WHERE sd.schedule_id = sh.schedule_id
271: AND sd.Calendar_id = sc.Calendar_id
272: AND sc.shopday_no = sl.shopday_no

Line 289: from ps_schd_dtl sd, ps_schd_hdr sh

285: CMPLT_DATE_V:=CMPLT_DATE;
286: SCHEDULE_VI := fnd_profile.value('GEMMS_DEFAULT_SCHEDULE');
287:
288: select count(*) into count2_v
289: from ps_schd_dtl sd, ps_schd_hdr sh
290: where sd.schedule_id = sh.schedule_id
291: and sh.schedule = SCHEDULE_VI
292: AND sd.orgn_code = PLANT_CODE_V1;
293: