511: --
512: CURSOR assign_dfv (p_policy_id NUMBER)
513: IS
514: SELECT 1
515: FROM hxt_per_aei_ddf_v aeiv
516: WHERE ( aeiv.hxt_rotation_plan = p_policy_id
517: OR aeiv.hxt_earning_policy = p_policy_id
518: OR aeiv.hxt_hour_deduction_policy = p_policy_id
519: OR aeiv.hxt_shift_differential_policy = p_policy_id
594: , hcl.element_type_id
595: FROM
596: hxt_earning_policies egp
597: , hxt_holiday_calendars hcl
598: , hxt_per_aei_ddf_v aeiv
599: , per_all_assignments_f asm
600: WHERE asm.assignment_id = p_assignment_id
601: AND asm.assignment_id = aeiv.assignment_id
602: AND c_date between aeiv.effective_start_date