APPS.PAY_HK_SOE_PKG dependencies on PAY_ACCRUAL_PLANS

Line 778: FROM pay_accrual_plans pap

774: ,ppa.payroll_id
775: ,pap.business_group_id
776: ,pap.accrual_plan_id
777: ,paa.assignment_id
778: FROM pay_accrual_plans pap
779: ,pay_element_types_f pet
780: ,pay_element_links_f pel
781: ,pay_element_entries_f pee
782: ,pay_assignment_actions paa

Line 817: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

813: SELECT MAX(locked_action_id)
814: FROM pay_action_interlocks
815: WHERE locking_action_id = p_assignment_action_id;
816:
817: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
818: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
819: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
820: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
821: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 818: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

814: FROM pay_action_interlocks
815: WHERE locking_action_id = p_assignment_action_id;
816:
817: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
818: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
819: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
820: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
821: l_business_group_id per_business_groups.business_group_id%TYPE;
822: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

Line 819: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;

815: WHERE locking_action_id = p_assignment_action_id;
816:
817: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
818: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
819: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
820: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
821: l_business_group_id per_business_groups.business_group_id%TYPE;
822: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
823: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 822: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

818: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
819: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
820: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
821: l_business_group_id per_business_groups.business_group_id%TYPE;
822: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
823: l_assignment_id per_assignments_f.assignment_id%TYPE;
824: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
825: l_annual_leave_balance NUMBER;
826: l_ovn NUMBER;