APPS.HXT_GEN_AAI dependencies on HXT_ROTATION_PLANS
Line 22: FROM hxt_rotation_plans rot
18:
19: /* Cursor to check for the rotation plan */
20: CURSOR chk_rot_plan IS
21: SELECT 'compatible' 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