APPS.POS_SPM_WF_PKG1 dependencies on PER_PEOPLE_F

Line 229: FROM per_people_f ppf, fnd_user fu

225: x_last_name OUT nocopy VARCHAR2)
226: IS
227: CURSOR l_per_cur IS
228: SELECT ppf.first_name, ppf.last_name
229: FROM per_people_f ppf, fnd_user fu
230: WHERE fu.employee_id = ppf.person_id
231: AND fu.user_id = p_user_id;
232: CURSOR l_tca_cur IS
233: SELECT hp.person_first_name, hp.person_last_name

Line 1580: FROM fnd_user fu, per_people_f ppf

1576: WHERE fu.user_id = l_user_id;
1577:
1578: CURSOR l_name_cur IS
1579: SELECT ppf.first_name, ppf.last_name
1580: FROM fnd_user fu, per_people_f ppf
1581: WHERE fu.user_id = l_user_id AND
1582: ppf.person_id = fu.employee_id;
1583:
1584: l_email_rec l_email_cur%ROWTYPE;