APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 656: FROM pay_accrual_plans pap,

652: , pap.accrual_units_of_measure
653: , ppa.payroll_id
654: , pap.business_group_id
655: , pap.accrual_plan_id
656: FROM pay_accrual_plans pap,
657: pay_element_types_f pet,
658: pay_element_links_f pel,
659: pay_element_entries_f pee,
660: pay_assignment_actions paa,

Line 681: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

677: AND paa.assignment_action_id = p_assignment_action_id;
678:
679:
680: l_action_info_id NUMBER;
681: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
682: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
683: l_accrual_category pay_accrual_plans.accrual_category%type;
684: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
685: l_payroll_id pay_all_payrolls_f.payroll_id%type;

Line 682: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

678:
679:
680: l_action_info_id NUMBER;
681: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
682: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
683: l_accrual_category pay_accrual_plans.accrual_category%type;
684: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
685: l_payroll_id pay_all_payrolls_f.payroll_id%type;
686: l_procedure_name VARCHAR2(80);

Line 683: l_accrual_category pay_accrual_plans.accrual_category%type;

679:
680: l_action_info_id NUMBER;
681: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
682: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
683: l_accrual_category pay_accrual_plans.accrual_category%type;
684: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
685: l_payroll_id pay_all_payrolls_f.payroll_id%type;
686: l_procedure_name VARCHAR2(80);
687: l_business_group_id NUMBER;

Line 684: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

680: l_action_info_id NUMBER;
681: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
682: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
683: l_accrual_category pay_accrual_plans.accrual_category%type;
684: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
685: l_payroll_id pay_all_payrolls_f.payroll_id%type;
686: l_procedure_name VARCHAR2(80);
687: l_business_group_id NUMBER;
688: l_effective_date DATE;