APPS.PAY_NZ_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 651: FROM pay_accrual_plans pap,

647: ,pap.accrual_units_of_measure
648: ,ppa.payroll_id
649: ,pap.business_group_id
650: ,pap.accrual_plan_id
651: FROM pay_accrual_plans pap,
652: pay_element_types_f pet,
653: pay_element_links_f pel,
654: pay_element_entries_f pee,
655: pay_assignment_actions paa,

Line 674: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%TYPE;

670: AND pee.effective_end_date
671: AND paa.assignment_id = p_assignment_id
672: AND paa.assignment_action_id = p_assignment_action_id;
673:
674: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
675: l_action_info_id NUMBER;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
677: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
678: l_annual_leave_balance NUMBER;

Line 676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

672: AND paa.assignment_action_id = p_assignment_action_id;
673:
674: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
675: l_action_info_id NUMBER;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
677: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
678: l_annual_leave_balance NUMBER;
679: l_ovn NUMBER;
680: l_payroll_id NUMBER;

Line 677: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

673:
674: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
675: l_action_info_id NUMBER;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
677: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
678: l_annual_leave_balance NUMBER;
679: l_ovn NUMBER;
680: l_payroll_id NUMBER;
681: l_bg_id NUMBER;