APPS.HXT_GEN_AAI dependencies on HXT_ROTATION_SCHEDULES
Line 26: FROM hxt_rotation_schedules hrs
22: FROM hxt_rotation_plans rot
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))