APPS.HXT_GEN_AAI dependencies on HXT_WEEKLY_WORK_SCHEDULES

Line 27: ,hxt_weekly_work_schedules wws

23: WHERE p_effective_start_date between rot.date_from
24: and nvl(rot.date_to, p_effective_start_date)
25: AND NOT EXISTS (SELECT '1'
26: FROM hxt_rotation_schedules hrs
27: ,hxt_weekly_work_schedules wws
28: WHERE hrs.rtp_id = rot.id
29: AND wws.id = hrs.tws_id
30: AND wws.business_group_id <> nvl(asg_bus_grp_id, -99))
31: AND rot.id = p_rotation_plan;