APPS.HXT_TIME_DETAIL dependencies on HXT_SHIFTS

Line 14523: FROM hxt_shifts hs,

14519: /*
14520: CURSOR csr_test_for_osp (p_assignment_id NUMBER, p_date_worked DATE)
14521: IS
14522: SELECT hws.off_shift_prem_id
14523: FROM hxt_shifts hs,
14524: hxt_work_shifts hws,
14525: hxt_per_aei_ddf_v aeiv,
14526: hxt_rotation_schedules hrs
14527: WHERE aeiv.assignment_id = p_assignment_id

Line 14551: hxt_shifts hs

14547: hws.off_shift_prem_id
14548: FROM hxt_per_aei_ddf_v aeiv,
14549: hxt_rotation_schedules hrs,
14550: hxt_work_shifts hws,
14551: hxt_shifts hs
14552: WHERE aeiv.assignment_id = p_assignment_id
14553: AND p_date_worked BETWEEN aeiv.effective_start_date
14554: AND aeiv.effective_end_date
14555: AND hrs.rtp_id = aeiv.hxt_rotation_plan