APPS.HXT_TIME_GEN dependencies on HXT_ROTATION_SCHEDULES

Line 737: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2

733: )
734: ),
735: hr_general.end_of_time
736: ) end_date
737: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2
738: WHERE rt1.rtp_id = rt2.rtp_id(+)
739: AND rt2.start_date(+) > rt1.start_date
740: AND rt1.rtp_id = c_rtp_id
741: AND c_end >= rt1.start_date