APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on BOM_SHIFT_TIMES

Line 1398: FROM bom_workday_patterns p, bom_calendar_shifts s, bom_shift_times st

1394: SELECT
1395: p.calendar_code,
1396: p.shift_num,
1397: SUM(p.days_on *( (DECODE ((SIGN (st.to_time - st.from_time) ),-1,((86400-st.from_time)+st.to_time),(st.to_time-st.from_time)) ) / 3600 )) work_hrs
1398: FROM bom_workday_patterns p, bom_calendar_shifts s, bom_shift_times st
1399: WHERE p.calendar_code = s.calendar_code
1400: AND p.shift_num = s.shift_num
1401: AND s.calendar_code = st.calendar_code
1402: AND s.shift_num = st.shift_num