APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 276: FROM pay_accrual_plans pap

272: ,pap.accrual_units_of_measure
273: ,ppa.payroll_id
274: ,pap.business_group_id
275: ,pap.accrual_plan_id
276: FROM pay_accrual_plans pap
277: ,pay_element_types_f pet
278: ,pay_element_links_f pel
279: ,pay_element_entries_f pee
280: ,pay_assignment_actions paa

Line 300: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

296: AND paa.assignment_action_id = p_assignment_action_id;
297: --
298:
299: l_action_info_id NUMBER;
300: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
301: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
302: l_accrual_category pay_accrual_plans.accrual_category%type;
303: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
304: l_payroll_id pay_all_payrolls_f.payroll_id%type;

Line 301: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

297: --
298:
299: l_action_info_id NUMBER;
300: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
301: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
302: l_accrual_category pay_accrual_plans.accrual_category%type;
303: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
304: l_payroll_id pay_all_payrolls_f.payroll_id%type;
305: l_business_group_id NUMBER;

Line 302: l_accrual_category pay_accrual_plans.accrual_category%type;

298:
299: l_action_info_id NUMBER;
300: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
301: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
302: l_accrual_category pay_accrual_plans.accrual_category%type;
303: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
304: l_payroll_id pay_all_payrolls_f.payroll_id%type;
305: l_business_group_id NUMBER;
306: l_effective_date DATE;

Line 303: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

299: l_action_info_id NUMBER;
300: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
301: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
302: l_accrual_category pay_accrual_plans.accrual_category%type;
303: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
304: l_payroll_id pay_all_payrolls_f.payroll_id%type;
305: l_business_group_id NUMBER;
306: l_effective_date DATE;
307: l_annual_leave_balance NUMBER;