APPS.POS_SPM_WF_PKG1 dependencies on PER_PEOPLE_F

Line 177: FROM per_people_f ppf, fnd_user fu

173: x_last_name OUT nocopy VARCHAR2)
174: IS
175: CURSOR l_per_cur IS
176: SELECT ppf.first_name, ppf.last_name
177: FROM per_people_f ppf, fnd_user fu
178: WHERE fu.employee_id = ppf.person_id
179: AND fu.user_id = p_user_id;
180: CURSOR l_tca_cur IS
181: SELECT hp.person_first_name, hp.person_last_name

Line 1528: FROM fnd_user fu, per_people_f ppf

1524: WHERE fu.user_id = l_user_id;
1525:
1526: CURSOR l_name_cur IS
1527: SELECT ppf.first_name, ppf.last_name
1528: FROM fnd_user fu, per_people_f ppf
1529: WHERE fu.user_id = l_user_id AND
1530: ppf.person_id = fu.employee_id;
1531:
1532: l_email_rec l_email_cur%ROWTYPE;