APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 450: FROM pay_accrual_plans pap

446: ,pap.accrual_units_of_measure accrual_uom
447: ,ppa.payroll_id payroll_id
448: ,pap.business_group_id business_group_id
449: ,pap.accrual_plan_id accrual_plan_id
450: FROM pay_accrual_plans pap
451: ,pay_element_types_f pet
452: ,pay_element_links_f pel
453: ,pay_element_entries_f pee
454: ,pay_assignment_actions paa

Line 474: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

470: AND paa.assignment_action_id = p_assignment_action_id;
471: --
472:
473: l_action_info_id NUMBER;
474: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
475: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
476: l_accrual_category pay_accrual_plans.accrual_category%type;
477: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
478: l_payroll_id pay_payrolls_f.payroll_id%type;

Line 475: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

471: --
472:
473: l_action_info_id NUMBER;
474: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
475: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
476: l_accrual_category pay_accrual_plans.accrual_category%type;
477: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
478: l_payroll_id pay_payrolls_f.payroll_id%type;
479: l_business_group_id NUMBER;

Line 476: l_accrual_category pay_accrual_plans.accrual_category%type;

472:
473: l_action_info_id NUMBER;
474: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
475: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
476: l_accrual_category pay_accrual_plans.accrual_category%type;
477: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
478: l_payroll_id pay_payrolls_f.payroll_id%type;
479: l_business_group_id NUMBER;
480: l_effective_date DATE;

Line 477: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

473: l_action_info_id NUMBER;
474: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
475: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
476: l_accrual_category pay_accrual_plans.accrual_category%type;
477: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
478: l_payroll_id pay_payrolls_f.payroll_id%type;
479: l_business_group_id NUMBER;
480: l_effective_date DATE;
481: l_annual_leave_balance NUMBER;