APPS.PAY_SA_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 1776: FROM pay_accrual_plans pap

1772: ,pap.accrual_units_of_measure
1773: ,ppa.payroll_id
1774: ,pap.business_group_id
1775: ,pap.accrual_plan_id
1776: FROM pay_accrual_plans pap
1777: ,pay_element_types_f pet
1778: ,pay_element_links_f pel
1779: ,pay_element_entries_f pee
1780: ,pay_assignment_actions paa

Line 1800: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

1796: AND paa.assignment_action_id = p_run_assignment_action_id;
1797: --
1798:
1799: l_action_info_id NUMBER;
1800: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1801: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1802: l_accrual_category pay_accrual_plans.accrual_category%type;
1803: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1804: l_payroll_id pay_all_payrolls_f.payroll_id%type;

Line 1801: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

1797: --
1798:
1799: l_action_info_id NUMBER;
1800: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1801: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1802: l_accrual_category pay_accrual_plans.accrual_category%type;
1803: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1804: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1805: l_business_group_id NUMBER;

Line 1802: l_accrual_category pay_accrual_plans.accrual_category%type;

1798:
1799: l_action_info_id NUMBER;
1800: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1801: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1802: l_accrual_category pay_accrual_plans.accrual_category%type;
1803: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1804: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1805: l_business_group_id NUMBER;
1806: l_effective_date DATE;

Line 1803: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

1799: l_action_info_id NUMBER;
1800: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1801: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1802: l_accrual_category pay_accrual_plans.accrual_category%type;
1803: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1804: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1805: l_business_group_id NUMBER;
1806: l_effective_date DATE;
1807: l_annual_leave_balance NUMBER;