DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on HXT_PER_AEI_DDF_V

Line 515: FROM hxt_per_aei_ddf_v aeiv

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

Line 598: , hxt_per_aei_ddf_v aeiv

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