eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_TIMES_PVT dependencies on BOM_CALENDAR_EXCEPTIONS

Line 1144: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1140: CURSOR get_holiday_csr(p_department_id IN NUMBER,
1141: p_start_date IN DATE,
1142: p_end_date IN DATE) IS
1143: SELECT COUNT(ex.EXCEPTION_DATE)
1144: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1145: WHERE ex.CALENDAR_CODE = dept.calendar_code
1146: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1147: AND dept.department_id = p_department_id
1148: AND ex.exception_date > p_start_date

Line 1349: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1345: --
1346: -- Fetch the holidays for the given department
1347: CURSOR l_exceptions_csr(p_department_id IN NUMBER) IS
1348: SELECT ex.EXCEPTION_DATE
1349: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1350: WHERE ex.CALENDAR_CODE = dept.calendar_code
1351: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1352: AND dept.department_id = p_department_id
1353: ORDER BY EXCEPTION_DATE;