APPS.PAY_SA_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 1884: FROM pay_accrual_plans pap

1880: ,pap.accrual_units_of_measure
1881: ,ppa.payroll_id
1882: ,pap.business_group_id
1883: ,pap.accrual_plan_id
1884: FROM pay_accrual_plans pap
1885: ,pay_element_types_f pet
1886: ,pay_element_links_f pel
1887: ,pay_element_entries_f pee
1888: ,pay_assignment_actions paa

Line 1908: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

1904: AND paa.assignment_action_id = p_run_assignment_action_id;
1905: --
1906:
1907: l_action_info_id NUMBER;
1908: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1909: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1910: l_accrual_category pay_accrual_plans.accrual_category%type;
1911: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1912: l_payroll_id pay_all_payrolls_f.payroll_id%type;

Line 1909: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

1905: --
1906:
1907: l_action_info_id NUMBER;
1908: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1909: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1910: l_accrual_category pay_accrual_plans.accrual_category%type;
1911: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1912: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1913: l_business_group_id NUMBER;

Line 1910: l_accrual_category pay_accrual_plans.accrual_category%type;

1906:
1907: l_action_info_id NUMBER;
1908: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1909: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1910: l_accrual_category pay_accrual_plans.accrual_category%type;
1911: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1912: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1913: l_business_group_id NUMBER;
1914: l_effective_date DATE;

Line 1911: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

1907: l_action_info_id NUMBER;
1908: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1909: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1910: l_accrual_category pay_accrual_plans.accrual_category%type;
1911: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1912: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1913: l_business_group_id NUMBER;
1914: l_effective_date DATE;
1915: l_annual_leave_balance NUMBER;