APPS.GMP_CALENDAR_API dependencies on BOM_SHIFT_DATES

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 800: bom_shift_dates sd,

796: c_end_date DATE) IS
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

Line 938: bom_shift_dates sd,

934: c_end_date DATE ) IS
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

Line 1386: bom_shift_dates sd,

1382:
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

Line 1562: bom_shift_dates sd,

1558: FROM sys.dual
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

Line 1580: bom_shift_dates sd,

1576:
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

Line 1599: bom_shift_dates sd,

1595: (decode(sign(st.from_time + (Decode(St.To_Time,0,86400,St.To_Time)- st.from_time) - 86400),1,(st.from_time
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

Line 1810: || ' bom_shift_dates sd, '

1806: || ' sd.shift_num shift_no, '
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 '