APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 351: FROM pay_accrual_plans pap

347: ,pap.accrual_units_of_measure
348: ,ppa.payroll_id
349: ,pap.business_group_id
350: ,pap.accrual_plan_id
351: FROM pay_accrual_plans pap
352: ,pay_element_types_f pet
353: ,pay_element_links_f pel
354: ,pay_element_entries_f pee
355: ,pay_assignment_actions paa

Line 375: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

371: AND paa.assignment_action_id = p_assignment_action_id;
372: --
373:
374: l_action_info_id NUMBER;
375: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
376: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
377: l_accrual_category pay_accrual_plans.accrual_category%type;
378: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
379: l_payroll_id pay_all_payrolls_f.payroll_id%type;

Line 376: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

372: --
373:
374: l_action_info_id NUMBER;
375: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
376: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
377: l_accrual_category pay_accrual_plans.accrual_category%type;
378: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
379: l_payroll_id pay_all_payrolls_f.payroll_id%type;
380: l_business_group_id NUMBER;

Line 377: l_accrual_category pay_accrual_plans.accrual_category%type;

373:
374: l_action_info_id NUMBER;
375: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
376: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
377: l_accrual_category pay_accrual_plans.accrual_category%type;
378: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
379: l_payroll_id pay_all_payrolls_f.payroll_id%type;
380: l_business_group_id NUMBER;
381: l_effective_date DATE;

Line 378: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

374: l_action_info_id NUMBER;
375: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
376: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
377: l_accrual_category pay_accrual_plans.accrual_category%type;
378: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
379: l_payroll_id pay_all_payrolls_f.payroll_id%type;
380: l_business_group_id NUMBER;
381: l_effective_date DATE;
382: l_annual_leave_balance NUMBER;

Line 418: select accrual_plan_name into l_accrual_plan_name from pay_accrual_plans_tl

414: AND t.language = Userenv ('LANG')
415: AND Substr (a.application_short_name, 1, 5) = 'PAY';
416:
417: IF TO_NUMBER(l_product_release) = 12 THEN
418: select accrual_plan_name into l_accrual_plan_name from pay_accrual_plans_tl
419: where accrual_plan_id = l_accrual_plan_id
420: and LANGUAGE = USERENV('LANG');
421: END IF;
422: /*Bug#14374752 Ends*/