APPS.CAC_AVLBLTY_PVT dependencies on CAC_SR_SCHDL_OBJECTS

Line 447: FROM CAC_SR_SCHDL_OBJECTS CSSO,

443: CSPCVL.PERIOD_CATEGORY_ID,
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,

Line 499: FROM CAC_SR_SCHDL_OBJECTS CSSO,

495: DECODE(CSEVL.HR_CAL_EVENT_TYPE,NULL,
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

Line 2039: FROM CAC_SR_SCHDL_OBJECTS

2035: SELECT SCHEDULE_OBJECT_ID
2036: , START_DATE_ACTIVE
2037: , END_DATE_ACTIVE
2038: , START_TEMPLATE_DETAIL_ID
2039: FROM CAC_SR_SCHDL_OBJECTS
2040: WHERE SCHEDULE_ID = b_schedule_id;
2041:
2042: l_period_data PERIOD_TBL_TYPE;
2043: l_schdl_dtls_data SCHDL_DETAILS_TBL_TYPE;

Line 2221: FROM CAC_SR_SCHDL_OBJECTS

2217: SELECT OBJECT_TYPE
2218: , OBJECT_ID
2219: , START_DATE_ACTIVE
2220: , END_DATE_ACTIVE
2221: FROM CAC_SR_SCHDL_OBJECTS
2222: WHERE SCHEDULE_ID = b_schedule_id;
2223:
2224: BEGIN
2225:

Line 2293: FROM CAC_SR_SCHDL_OBJECTS CSSO,

2289: , CSSO.OBJECT_ID
2290: , CSSO.START_DATE_ACTIVE
2291: , CSSO.END_DATE_ACTIVE
2292: , CSSD.SCHEDULE_OBJECT_ID
2293: FROM CAC_SR_SCHDL_OBJECTS CSSO,
2294: (SELECT SCHEDULE_OBJECT_ID, MIN(START_DATE_TIME)
2295: FROM CAC_SR_SCHDL_DETAILS
2296: WHERE SCHEDULE_ID = b_schedule_id
2297: ) CSSD