APPS.PAY_IN_SOE_PKG dependencies on PAY_ACCRUAL_PLANS

Line 863: FROM pay_accrual_plans pap

859: ,ppa.payroll_id
860: ,pap.business_group_id
861: ,pap.accrual_plan_id
862: ,paa.assignment_id
863: FROM pay_accrual_plans pap
864: ,pay_element_types_f pet
865: ,pay_element_links_f pel
866: ,pay_element_entries_f pee
867: ,pay_assignment_actions paa

Line 898: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

894: SELECT MAX(locked_action_id)
895: FROM pay_action_interlocks
896: WHERE locking_action_id = p_assignment_action_id;
897:
898: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
899: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
900: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
901: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
902: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 899: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

895: FROM pay_action_interlocks
896: WHERE locking_action_id = p_assignment_action_id;
897:
898: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
899: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
900: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
901: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
902: l_business_group_id per_business_groups.business_group_id%TYPE;
903: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

Line 900: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;

896: WHERE locking_action_id = p_assignment_action_id;
897:
898: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
899: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
900: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
901: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
902: l_business_group_id per_business_groups.business_group_id%TYPE;
903: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
904: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 903: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

899: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
900: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
901: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
902: l_business_group_id per_business_groups.business_group_id%TYPE;
903: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
904: l_assignment_id per_assignments_f.assignment_id%TYPE;
905: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
906: l_annual_leave_balance NUMBER;
907: l_ovn NUMBER;