APPS.PAY_CN_SOE dependencies on PAY_ACCRUAL_PLANS

Line 484: FROM pay_accrual_plans pap

480: ,ppa.payroll_id
481: ,pap.business_group_id
482: ,pap.accrual_plan_id
483: ,paa.assignment_id
484: FROM pay_accrual_plans pap
485: ,pay_element_types_f pet
486: ,pay_element_links_f pel
487: ,pay_element_entries_f pee
488: ,pay_assignment_actions paa

Line 519: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

515: SELECT MAX(locked_action_id)
516: FROM pay_action_interlocks
517: WHERE locking_action_id = p_assignment_action_id;
518:
519: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
520: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
521: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
522: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
523: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 520: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

516: FROM pay_action_interlocks
517: WHERE locking_action_id = p_assignment_action_id;
518:
519: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
520: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
521: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
522: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
523: l_business_group_id per_business_groups.business_group_id%TYPE;
524: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

Line 521: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;

517: WHERE locking_action_id = p_assignment_action_id;
518:
519: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
520: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
521: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
522: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
523: l_business_group_id per_business_groups.business_group_id%TYPE;
524: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
525: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 524: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

520: l_accrual_category pay_accrual_plans.accrual_category%TYPE;
521: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
522: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
523: l_business_group_id per_business_groups.business_group_id%TYPE;
524: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
525: l_assignment_id per_assignments_f.assignment_id%TYPE;
526: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
527: l_annual_leave_balance NUMBER;
528: l_ovn NUMBER;