DBA Data[Home] [Help]

APPS.CAC_AVLBLTY_PVT dependencies on CAC_SR_PERIOD_CATS_VL

Line 451: CAC_SR_PERIOD_CATS_VL CSPCVL,

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
453: WHERE CSSO.OBJECT_TYPE = b_object_type
454: AND CSSO.OBJECT_ID = b_object_id
455: AND CSSO.START_DATE_ACTIVE <= b_end_dt

Line 503: CAC_SR_PERIOD_CATS_VL CSPVL

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
507: AND CSSO.END_DATE_ACTIVE >= b_start_dt