APPS.HXT_TIMECARD_INFO dependencies on HXT_ROTATION_SCHEDULES

Line 956: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2

952: -- reverting back this change since the cursor returns wrong
953: -- end_date when rt2.start_date is NULL
954: /* NVL(least(min(rt2.start_date-1),p_end)
955: ,hr_general.end_of_time ) end_date*/
956: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2
957: WHERE rt1.rtp_id = rt2.rtp_id(+)
958: AND rt2.start_date(+) > rt1.start_date
959: AND rt1.rtp_id = p_rtp_id
960: AND p_end >= rt1.start_date