DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on HXT_PER_AEI_DDF_V

Line 511: FROM hxt_per_aei_ddf_v aeiv

507: --
508: CURSOR assign_dfv (p_policy_id NUMBER)
509: IS
510: SELECT 1
511: FROM hxt_per_aei_ddf_v aeiv
512: WHERE ( aeiv.hxt_rotation_plan = p_policy_id
513: OR aeiv.hxt_earning_policy = p_policy_id
514: OR aeiv.hxt_hour_deduction_policy = p_policy_id
515: OR aeiv.hxt_shift_differential_policy = p_policy_id

Line 594: , hxt_per_aei_ddf_v aeiv

590: , hcl.element_type_id
591: FROM
592: hxt_earning_policies egp
593: , hxt_holiday_calendars hcl
594: , hxt_per_aei_ddf_v aeiv
595: , per_all_assignments_f asm
596: WHERE asm.assignment_id = p_assignment_id
597: AND asm.assignment_id = aeiv.assignment_id
598: AND c_date between aeiv.effective_start_date