APPS.AHL_VWP_TIMES_PVT dependencies on BOM_SHIFT_TIMES

Line 361: -- Shift_Num is unique in bom_shift_times

357: --
358: -- ASSUMPTIONS:
359: -- A Task can appear only once for a given visit (ahl_visit_tasks_b)
360: -- A Department can have only one shift (ahl_department_shifts)
361: -- Shift_Num is unique in bom_shift_times
362: --
363: -------------------------------------------------------------------
364: PROCEDURE Calculate_Task_Times
365: (

Line 1337: FROM bom_shift_times times, bom_workday_patterns pattern,

1333: CURSOR l_shift_info_csr(p_department_id IN NUMBER) IS
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