APPS.CAC_AVLBLTY_PVT dependencies on CAC_SR_EXCEPTIONS_VL

Line 502: CAC_SR_EXCEPTIONS_VL CSEVL,

498: DECODE(CSEVL.HR_CAL_EVENT_ID,NULL,6,5),4)) LEVEL_IND
499: FROM CAC_SR_SCHDL_OBJECTS CSSO,
500: CAC_SR_SCHEDULES_B CSSB,
501: CAC_SR_SCHDL_EXCEPTIONS CSSE,
502: CAC_SR_EXCEPTIONS_VL CSEVL,
503: CAC_SR_PERIOD_CATS_VL CSPVL
504: WHERE CSSO.OBJECT_TYPE = b_object_type
505: AND CSSO.OBJECT_ID = b_object_id
506: AND CSSO.START_DATE_ACTIVE <= b_end_dt