153: ln_business_group_id NUMBER;
154: ln_tax_unit_id NUMBER := 0;
155: ln_person_id NUMBER := 0;
156: ln_asg_set NUMBER := 0;
157: lv_ssn per_people_f.national_identifier%TYPE;
158: lv_year VARCHAR2(4) := 0;
159:
160: BEGIN
161: hr_utility.trace('Entered get_payroll_action_info');
214: ld_start_date DATE;
215: ln_business_group_id NUMBER;
216: ln_tax_unit_id NUMBER;
217: ln_person_id NUMBER := 0;
218: lv_ssn per_people_f.national_identifier%TYPE ;
219: ln_asg_set NUMBER := 0;
220: lv_year VARCHAR2(4) := 0;
221: lv_sql_string VARCHAR2(32000);
222: ln_eoy_pactid number;
298: ld_start_date DATE;
299: ln_business_group_id NUMBER;
300: ln_person_id NUMBER := 0 ;
301: ln_person_id_sel NUMBER := 0 ;
302: lv_ssn per_people_f.national_identifier%TYPE ;
303: ln_asg_set NUMBER := 0 ;
304: ln_prev_asg_action_id NUMBER := 0;
305: ln_prev_assignment_id NUMBER := 0;
306: ln_prev_tax_unit_id NUMBER := 0;