DBA Data[Home] [Help]

APPS.AHL_VWP_TIMES_PVT dependencies on BOM_CALENDARS

Line 1247: bom_calendars cal, ahl_department_shifts dept

1243: SELECT TRUNC(cal.CALENDAR_START_DATE), TRUNC(cal.CALENDAR_END_DATE),
1244: times.FROM_TIME/G_SECS_IN_DAY, times.TO_TIME/G_SECS_IN_DAY,
1245: pattern.DAYS_ON, pattern.DAYS_OFF
1246: FROM bom_shift_times times, bom_workday_patterns pattern,
1247: bom_calendars cal, ahl_department_shifts dept
1248: WHERE dept.calendar_code = times.calendar_code
1249: AND dept.shift_num = times.shift_num
1250: AND pattern.calendar_code = dept.calendar_code
1251: AND pattern.shift_num = dept.shift_num