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: ))
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: ))