APPS.AHL_VWP_TIMES_PVT dependencies on AHL_DEPARTMENT_SHIFTS

Line 1017: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1013: CURSOR get_holiday_csr(p_department_id IN NUMBER,
1014: p_start_date IN DATE,
1015: p_end_date IN DATE) IS
1016: SELECT COUNT(ex.EXCEPTION_DATE)
1017: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1018: WHERE ex.CALENDAR_CODE = dept.calendar_code
1019: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1020: AND dept.department_id = p_department_id
1021: AND ex.exception_date > p_start_date

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

Line 1259: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1255: --
1256: -- Fetch the holidays for the given department
1257: CURSOR l_exceptions_csr(p_department_id IN NUMBER) IS
1258: SELECT ex.EXCEPTION_DATE
1259: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1260: WHERE ex.CALENDAR_CODE = dept.calendar_code
1261: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1262: AND dept.department_id = p_department_id
1263: ORDER BY EXCEPTION_DATE;

Line 1525: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1521: CURSOR get_holiday_csr(c_department_id IN NUMBER,
1522: c_start_date IN DATE,
1523: c_end_date IN DATE) IS
1524: SELECT COUNT(ex.EXCEPTION_DATE)
1525: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1526: WHERE ex.CALENDAR_CODE = dept.calendar_code
1527: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1528: AND dept.department_id = c_department_id
1529: AND ex.exception_date > c_start_date