APPS.CAC_AVLBLTY_PVT dependencies on CAC_SR_SCHEDULES_B

Line 448: CAC_SR_SCHEDULES_B CSSB,

444: CSPCVL.PERIOD_CATEGORY_NAME,
445: DECODE(CSPCVL.FREE_BUSY_TYPE,'FREE','FREE','BUSY','BUSY',NVL(b_busy_tentative,'TENTATIVE')) FREE_BUSY_TYPE,
446: CSPCVL.DISPLAY_COLOR
447: FROM CAC_SR_SCHDL_OBJECTS CSSO,
448: CAC_SR_SCHEDULES_B CSSB,
449: CAC_SR_SCHDL_DETAILS CSSD,
450: CAC_SR_PERIODS_VL CSPVL,
451: CAC_SR_PERIOD_CATS_VL CSPCVL,
452: FND_LOOKUPS FL

Line 500: CAC_SR_SCHEDULES_B CSSB,

496: DECODE(CSEVL.HR_CAL_EVENT_ID,NULL,3,2),1),
497: DECODE(CSEVL.HR_CAL_EVENT_TYPE,NULL,
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

Line 2137: FROM CAC_SR_SCHEDULES_B CSSB

2133: , CSTB.TEMPLATE_TYPE
2134: , CSTB.TEMPLATE_LENGTH_DAYS
2135: , CSSB.START_DATE_ACTIVE
2136: , CSSB.END_DATE_ACTIVE
2137: FROM CAC_SR_SCHEDULES_B CSSB
2138: , CAC_SR_TEMPLATES_B CSTB
2139: WHERE CSSB.SCHEDULE_ID = b_schedule_id
2140: AND CSTB.TEMPLATE_ID = CSSB.TEMPLATE_ID;
2141: