DBA Data[Home] [Help]

APPS.HR_WRK_SCH_PKG dependencies on CAC_SR_PUBLISH_SCHEDULES

Line 85: FROM cac_sr_publish_schedules

81: AND CSSB.deleted_date IS NULL
82: AND (CSSB.schedule_category = cp_sch_cat
83: OR
84: CSSB.schedule_id IN (SELECT schedule_id
85: FROM cac_sr_publish_schedules
86: WHERE object_type = cp_object_type
87: AND object_id = cp_object_id
88: AND cp_sch_cat IS NULL
89: )

Line 110: FROM cac_sr_publish_schedules

106: AND CSSB.deleted_date IS NULL
107: AND (CSSB.schedule_category = cp_sch_cat
108: OR
109: CSSB.schedule_id IN (SELECT schedule_id
110: FROM cac_sr_publish_schedules
111: WHERE object_type = cp_object_type
112: AND object_id = cp_object_id
113: AND cp_sch_cat IS NULL
114: )

Line 517: FROM cac_sr_publish_schedules

513: AND CSSB.deleted_date IS NULL
514: AND (CSSB.schedule_category = cp_sch_cat
515: OR
516: CSSB.schedule_id IN (SELECT schedule_id
517: FROM cac_sr_publish_schedules
518: WHERE object_type = cp_object_type
519: AND object_id = cp_object_id
520: AND cp_sch_cat IS NULL
521: )

Line 544: FROM cac_sr_publish_schedules

540: AND CSSB.deleted_date IS NULL
541: AND (CSSB.schedule_category = cp_sch_cat
542: OR
543: CSSB.schedule_id IN (SELECT schedule_id
544: FROM cac_sr_publish_schedules
545: WHERE object_type = cp_object_type
546: AND object_id = cp_object_id
547: AND cp_sch_cat IS NULL
548: )