DBA Data[Home] [Help]

APPS.PAY_US_W2C_ARCH dependencies on PER_PEOPLE_F

Line 157: lv_ssn per_people_f.national_identifier%TYPE;

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');

Line 218: lv_ssn per_people_f.national_identifier%TYPE ;

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;

Line 302: lv_ssn per_people_f.national_identifier%TYPE ;

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;