APPS.HR_US_W2_REP dependencies on PER_ALL_PEOPLE_F

Line 889: FROM per_all_people_f ppf

885: RETURN VARCHAR2 IS
886:
887: CURSOR c_w2_emp_name IS
888: SELECT ppf.last_name|| ' ' || ppf.first_name || ' ' || substr(ppf.middle_names,1,1) emp_name
889: FROM per_all_people_f ppf
890: WHERE ppf.person_id = w2_person_id
891: AND w2_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
892:
893: c_w2_emp_name_rec c_w2_emp_name%ROWTYPE;

Line 1740: FROM per_all_people_f peo

1736: l_emp_number varchar2(30);
1737:
1738: BEGIN
1739: SELECT peo.employee_number INTO l_emp_number
1740: FROM per_all_people_f peo
1741: WHERE peo.national_identifier = w2_nat_ident
1742: AND w2_effective_date BETWEEN peo.effective_start_date
1743: AND peo.effective_end_date;
1744: RETURN(l_emp_number);