DBA Data[Home] [Help]

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