APPS.PAY_IN_SOE_PKG dependencies on PAY_ACCRUAL_PLANS

Line 866: FROM pay_accrual_plans pap

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

Line 901: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

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

Line 902: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

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

Line 903: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;

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

Line 906: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

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