APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on BOM_CALENDAR_EXCEPTIONS

Line 4071: SELECT EXCEPTION_DATE FROM bom_calendar_exceptions

4067: SELECT CALENDAR_START_DATE, CALENDAR_END_DATE FROM bom_calendars
4068: WHERE CALENDAR_CODE = p_calendar_code;
4069:
4070: CURSOR l_exceptions_csr(p_calendar_code IN VARCHAR2) IS
4071: SELECT EXCEPTION_DATE FROM bom_calendar_exceptions
4072: WHERE CALENDAR_CODE = p_calendar_code AND
4073: EXCEPTION_TYPE = G_HOLIDAY_TYPE
4074: ORDER BY EXCEPTION_DATE;
4075: --

Line 4323: SELECT 'x' INTO l_junk FROM AHL_DEPARTMENT_SHIFTS ADS, BOM_CALENDAR_EXCEPTIONS BCE

4319: FUNCTION Not_A_Holiday(p_curr_date DATE, p_dept_id NUMBER) RETURN BOOLEAN
4320: IS
4321: l_junk VARCHAR2(1);
4322: BEGIN
4323: SELECT 'x' INTO l_junk FROM AHL_DEPARTMENT_SHIFTS ADS, BOM_CALENDAR_EXCEPTIONS BCE
4324: WHERE ADS.DEPARTMENT_ID = p_dept_id AND
4325: BCE.CALENDAR_CODE = ADS.CALENDAR_CODE AND
4326: BCE.EXCEPTION_TYPE = G_HOLIDAY_TYPE AND
4327: TRUNC(BCE.EXCEPTION_DATE) = TRUNC(p_curr_date);