APPS.GMP_CALENDAR_API dependencies on BOM_SHIFT_TIMES

Line 72: FROM BOM_shift_dates sd, bom_shift_times sht

68: CURSOR get_day_cur (c_calendar_id VARCHAR2 , c_cal_date DATE) IS
69: SELECT 1 FROM dual
70: WHERE EXISTS
71: (SELECT 1
72: FROM BOM_shift_dates sd, bom_shift_times sht
73: WHERE sd.calendar_code = sht.calendar_code
74: AND sd.shift_date = trunc(c_cal_date)
75: AND sd.shift_num = sht.shift_num
76: AND sd.calendar_code = c_calendar_id

Line 801: bom_shift_times st

797: SELECT sd.shift_date calendar_date,
798: decode(SUM(decode(sd.seq_num,NULL,0,1)),0,0,1) l_work_day
799: FROM bom_calendars cal,
800: bom_shift_dates sd,
801: bom_shift_times st
802: WHERE cal.calendar_code = c_calendar_code
803: AND sd.calendar_code = cal.calendar_code
804: AND st.calendar_code = sd.calendar_code
805: AND sd.shift_date BETWEEN trunc(c_start_date) AND trunc(c_end_date)

Line 939: bom_shift_times st

935: SELECT sd.shift_date calendar_date,
936: SUM((DECODE(st.to_time,0,86400,st.to_time) - st.from_time)/3600) duration
937: FROM bom_calendars cal,
938: bom_shift_dates sd,
939: bom_shift_times st
940: WHERE cal.calendar_code = c_calendar_code
941: AND sd.calendar_code = cal.calendar_code
942: AND st.calendar_code = sd.calendar_code
943: AND sd.shift_date BETWEEN trunc(c_start_date) AND trunc(c_end_date)

Line 1051: FROM bom_shift_times

1047:
1048: CURSOR shopday_dtls_cur (c_calendar_code VARCHAR2,
1049: c_shopday_no NUMBER) IS
1050: SELECT shift_num,from_time,DECODE(to_time,0,86400,to_time) to_time
1051: FROM bom_shift_times
1052: WHERE calendar_code = c_calendar_code
1053: AND shift_num = c_shopday_no
1054: ORDER BY from_time ;
1055:

Line 1059: FROM bom_shift_times

1055:
1056: CURSOR Cur_shop_day (c_calendar_code VARCHAR2,
1057: c_shopday_no NUMBER) IS
1058: SELECT COUNT(*)
1059: FROM bom_shift_times
1060: WHERE calendar_code = c_calendar_code
1061: AND shift_num = c_shopday_no;
1062:
1063: i INTEGER := 0 ;

Line 1387: bom_shift_times st

1383: CURSOR get_datetime_cur (c_calendar_code VARCHAR2, c_cal_date DATE) IS
1384: SELECT 1
1385: FROM bom_calendars cal,
1386: bom_shift_dates sd,
1387: bom_shift_times st
1388: WHERE cal.calendar_code = c_calendar_code
1389: AND sd.calendar_code = cal.calendar_code
1390: AND st.calendar_code = sd.calendar_code
1391: AND sd.shift_num = st.shift_num

Line 1563: bom_shift_times st

1559: WHERE EXISTS (
1560: select 'x'
1561: FROM bom_calendars bd,
1562: bom_shift_dates sd,
1563: bom_shift_times st
1564: WHERE bd.calendar_code = p_calendar_id
1565: AND sd.calendar_code = bd.calendar_code
1566: AND sd.calendar_code= st.calendar_code
1567: AND sd.shift_num = st.shift_num

Line 1581: bom_shift_times st

1577: CURSOR get_NextDatetime_cur (p_calendar_id VARCHAR2 , p_cal_date DATE) IS
1578: SELECT min (sd.shift_date + (st.from_time/86400))
1579: FROM bom_calendars bd,
1580: bom_shift_dates sd,
1581: bom_shift_times st
1582: WHERE bd.calendar_code = p_calendar_id
1583: AND sd.calendar_code = bd.calendar_code
1584: AND sd.calendar_code= st.calendar_code
1585: AND sd.shift_num = st.shift_num

Line 1600: bom_shift_times st

1596: + (Decode(St.To_Time,0,86400,St.To_Time)- st.from_time) - 86400),(st.from_time + (Decode(St.To_Time,0,86400,St.To_Time)- st.from_time)))/86400 ) )
1597: )
1598: FROM bom_calendars bd,
1599: bom_shift_dates sd,
1600: bom_shift_times st
1601: WHERE bd.calendar_code = p_calendar_id
1602: AND sd.calendar_code = bd.calendar_code
1603: AND sd.calendar_code= st.calendar_code
1604: AND sd.shift_num = st.shift_num

Line 1811: || ' bom_shift_times st '

1807: || ' st.from_time from_time, '
1808: || ' decode(st.to_time,0,86400,st.to_time) to_time '
1809: || ' FROM bom_calendars cal, '
1810: || ' bom_shift_dates sd, '
1811: || ' bom_shift_times st '
1812: || ' WHERE cal.calendar_code = :curr_cal_code '
1813: || ' AND sd.calendar_code = cal.calendar_code '
1814: || ' AND st.calendar_code = sd.calendar_code '
1815: || ' AND sd.shift_num = st.shift_num '