APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 838: FROM pay_accrual_plans pap,

834: , pap.accrual_units_of_measure
835: , ppa.payroll_id
836: , pap.business_group_id
837: , pap.accrual_plan_id
838: FROM pay_accrual_plans pap,
839: pay_element_types_f pet,
840: pay_element_links_f pel,
841: pay_element_entries_f pee,
842: pay_assignment_actions paa,

Line 863: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

859: AND paa.assignment_action_id = p_assignment_action_id;
860:
861:
862: l_action_info_id NUMBER;
863: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
864: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
865: l_accrual_category pay_accrual_plans.accrual_category%type;
866: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
867: l_payroll_id pay_payrolls_f.payroll_id%type;

Line 864: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

860:
861:
862: l_action_info_id NUMBER;
863: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
864: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
865: l_accrual_category pay_accrual_plans.accrual_category%type;
866: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
867: l_payroll_id pay_payrolls_f.payroll_id%type;
868: l_procedure_name VARCHAR2(80);

Line 865: l_accrual_category pay_accrual_plans.accrual_category%type;

861:
862: l_action_info_id NUMBER;
863: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
864: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
865: l_accrual_category pay_accrual_plans.accrual_category%type;
866: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
867: l_payroll_id pay_payrolls_f.payroll_id%type;
868: l_procedure_name VARCHAR2(80);
869: l_business_group_id NUMBER;

Line 866: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

862: l_action_info_id NUMBER;
863: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
864: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
865: l_accrual_category pay_accrual_plans.accrual_category%type;
866: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
867: l_payroll_id pay_payrolls_f.payroll_id%type;
868: l_procedure_name VARCHAR2(80);
869: l_business_group_id NUMBER;
870: l_effective_date DATE;