APPS.PAY_SE_ABSENCE dependencies on CAC_SR_PUBLISH_SCHEDULES

Line 3242: FROM CAC_SR_PUBLISH_SCHEDULES

3238: AND CSSO.SCHEDULE_ID = CSSB.SCHEDULE_ID
3239: AND CSSB.DELETED_DATE IS NULL
3240: AND (CSSB.SCHEDULE_CATEGORY = b_schdl_cat
3241: OR CSSB.SCHEDULE_ID IN (SELECT SCHEDULE_ID
3242: FROM CAC_SR_PUBLISH_SCHEDULES
3243: WHERE OBJECT_TYPE = b_object_type
3244: AND OBJECT_ID = b_object_id
3245: AND b_schdl_cat IS NULL
3246: ));