DBA Data[Home] [Help]

APPS.PAY_US_W2C_ARCH dependencies on PER_PEOPLE_F

Line 160: lv_ssn per_people_f.national_identifier%TYPE;

156: ln_business_group_id NUMBER;
157: ln_tax_unit_id NUMBER := 0;
158: ln_person_id NUMBER := 0;
159: ln_asg_set NUMBER := 0;
160: lv_ssn per_people_f.national_identifier%TYPE;
161: lv_year VARCHAR2(4) := 0;
162:
163: BEGIN
164: hr_utility.trace('Entered get_payroll_action_info');

Line 221: lv_ssn per_people_f.national_identifier%TYPE ;

217: ld_start_date DATE;
218: ln_business_group_id NUMBER;
219: ln_tax_unit_id NUMBER;
220: ln_person_id NUMBER := 0;
221: lv_ssn per_people_f.national_identifier%TYPE ;
222: ln_asg_set NUMBER := 0;
223: lv_year VARCHAR2(4) := 0;
224: lv_sql_string VARCHAR2(32000);
225: ln_eoy_pactid number;

Line 305: lv_ssn per_people_f.national_identifier%TYPE ;

301: ld_start_date DATE;
302: ln_business_group_id NUMBER;
303: ln_person_id NUMBER := 0 ;
304: ln_person_id_sel NUMBER := 0 ;
305: lv_ssn per_people_f.national_identifier%TYPE ;
306: ln_asg_set NUMBER := 0 ;
307: ln_prev_asg_action_id NUMBER := 0;
308: ln_prev_assignment_id NUMBER := 0;
309: ln_prev_tax_unit_id NUMBER := 0;