APPS.HXT_TIME_GEN dependencies on HXT_ROTATION_SCHEDULES

Line 604: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2

600: )
601: ),
602: hr_general.end_of_time
603: ) end_date
604: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2
605: WHERE rt1.rtp_id = rt2.rtp_id(+)
606: AND rt2.start_date(+) > rt1.start_date
607: AND rt1.rtp_id = c_rtp_id
608: AND c_end >= rt1.start_date