APPS.PMI_PRODUCTION_SUM dependencies on PS_SCHD_HDR

Line 389: FUNCTION SCHD_WORK_HOUR(BATCH_ID_VI IN INTEGER, SCHEDULE_VI IN ps_schd_hdr.schedule%type)

385:
386: return ADJUST_BATCH_v;
387: end NO_OF_TIMES_ADJUSTED;
388:
389: FUNCTION SCHD_WORK_HOUR(BATCH_ID_VI IN INTEGER, SCHEDULE_VI IN ps_schd_hdr.schedule%type)
390: RETURN NUMBER
391: is
392: ACTUAL_START_DATE_V GME_BATCH_HEADER.ACTUAL_START_DATE%type;
393: ACTUAL_CMPLT_DATE_V GME_BATCH_HEADER.ACTUAL_CMPLT_DATE%type;

Line 410: SCHEDULE_V PS_SCHD_HDR.SCHEDULE%TYPE,

406: batch_hrs_v NUMBER;
407: Batch_day_V1 DATE;
408:
409: CURSOR shop_cal_CUR(
410: SCHEDULE_V PS_SCHD_HDR.SCHEDULE%TYPE,
411: PLANT_CODE_V GME_BATCH_HEADER.PLANT_CODE%type,
412: Batch_day_V DATE )
413: IS
414: SELECT shift_start,shift_duration

Line 415: FROM ps_schd_dtl sd, ps_schd_hdr sh,

411: PLANT_CODE_V GME_BATCH_HEADER.PLANT_CODE%type,
412: Batch_day_V DATE )
413: IS
414: SELECT shift_start,shift_duration
415: FROM ps_schd_dtl sd, ps_schd_hdr sh,
416: mr_shcl_dtl sc, mr_shdy_dtl sl
417: WHERE sd.schedule_id = sh.schedule_id
418: AND sd.Calendar_id = sc.Calendar_id
419: AND sc.shopday_no = sl.shopday_no

Line 432: from ps_schd_dtl sd, ps_schd_hdr sh

428: from gme_batch_header
429: where batch_id = batch_id_vi;
430:
431: select count(*) into count2_v
432: from ps_schd_dtl sd, ps_schd_hdr sh
433: where sd.schedule_id = sh.schedule_id
434: and sh.schedule = SCHEDULE_VI
435: AND sd.orgn_code = PLANT_CODE_V1;
436: