DBA Data[Home] [Help]

APPS.CAC_AVLBLTY_PVT dependencies on CAC_SR_PUBLISH_SCHEDULES

Line 461: FROM CAC_SR_PUBLISH_SCHEDULES

457: AND CSSO.SCHEDULE_ID = CSSB.SCHEDULE_ID
458: AND CSSB.DELETED_DATE IS NULL
459: AND (CSSB.SCHEDULE_CATEGORY = b_schdl_cat
460: OR CSSB.SCHEDULE_ID IN (SELECT SCHEDULE_ID
461: FROM CAC_SR_PUBLISH_SCHEDULES
462: WHERE OBJECT_TYPE = b_object_type
463: AND OBJECT_ID = b_object_id
464: AND b_schdl_cat IS NULL
465: ))

Line 512: FROM CAC_SR_PUBLISH_SCHEDULES

508: AND CSSO.SCHEDULE_ID = CSSB.SCHEDULE_ID
509: AND CSSB.DELETED_DATE IS NULL
510: AND (CSSB.SCHEDULE_CATEGORY = b_schdl_cat
511: OR CSSB.SCHEDULE_ID IN (SELECT SCHEDULE_ID
512: FROM CAC_SR_PUBLISH_SCHEDULES
513: WHERE OBJECT_TYPE = b_object_type
514: AND OBJECT_ID = b_object_id
515: AND b_schdl_cat IS NULL
516: ))