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 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 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