DBA Data[Home] [Help]

APPS.AHL_VWP_TIMES_PVT dependencies on BOM_CALENDARS

Line 1338: bom_calendars cal, ahl_department_shifts dept

1334: SELECT TRUNC(cal.CALENDAR_START_DATE), TRUNC(cal.CALENDAR_END_DATE),
1335: times.FROM_TIME/G_SECS_IN_DAY, times.TO_TIME/G_SECS_IN_DAY,
1336: pattern.DAYS_ON, pattern.DAYS_OFF
1337: FROM bom_shift_times times, bom_workday_patterns pattern,
1338: bom_calendars cal, ahl_department_shifts dept
1339: WHERE dept.calendar_code = times.calendar_code
1340: AND dept.shift_num = times.shift_num
1341: AND pattern.calendar_code = dept.calendar_code
1342: AND pattern.shift_num = dept.shift_num