APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on BOM_WORKDAY_PATTERNS

Line 1189: FROM bom_workday_patterns

1185:
1186: /*Computes the work ratio*/
1187: OPEN cur_cal_work_ratio FOR
1188: SELECT (sum(days_on) + sum(days_off) )/ sum(days_on) work_ratio
1189: FROM bom_workday_patterns
1190: WHERE shift_num is NULL
1191: AND calendar_code = p_calendar_code ;
1192:
1193: FETCH cur_cal_work_ratio INTO l_work_ratio ;

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

1199: SELECT
1200: p.calendar_code,
1201: p.shift_num,
1202: 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
1203: FROM bom_workday_patterns p, bom_calendar_shifts s, bom_shift_times st
1204: WHERE p.calendar_code = s.calendar_code
1205: AND p.shift_num = s.shift_num
1206: AND s.calendar_code = st.calendar_code
1207: AND s.shift_num = st.shift_num

Line 1221: FROM bom_workday_patterns p, bom_calendar_shifts s

1217: /*B5146342 - moved this cursor from outside to calculate appropriate work hours*/
1218: OPEN cur_tot_shft_days FOR
1219: SELECT
1220: (sum(p.days_on) + sum(p.days_off)) tot_days
1221: FROM bom_workday_patterns p, bom_calendar_shifts s
1222: WHERE p.calendar_code = s.calendar_code
1223: AND p.shift_num = l_shift_num
1224: AND s.shift_num = p.shift_num
1225: AND p.shift_num is NOT NULL