APPS.HR_US_W2_REP dependencies on PER_ALL_PEOPLE_F
Line 1625: FROM per_all_people_f peo
1621: l_emp_number varchar2(30);
1622:
1623: BEGIN
1624: SELECT peo.employee_number INTO l_emp_number 1625: FROM per_all_people_f peo 1626: WHERE peo.national_identifier = w2_nat_ident
1627: AND w2_effective_date BETWEEN peo.effective_start_date
1628: AND peo.effective_end_date;
1629: RETURN(l_emp_number);