DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on PER_PEOPLE_X

Line 755: | with per_people_x

751: | MODIFICATION HISTORY
752: | Date Author Description of Changes
753: | 25-May-2002 J Rautiainen Created
754: | 19-Aug-2004 skoukunt 3838623:replace per_workforce_x
755: | with per_people_x
756: |
757: *=======================================================================*/
758: FUNCTION get_employee_name(p_user_id IN NUMBER) RETURN VARCHAR2 IS
759:

Line 769: from fnd_user usr, per_people_x per

765: CURSOR user_cur IS
766: select DECODE(per.PERSON_ID,
767: null, usr.USER_NAME,
768: per.full_name) employee_name
769: from fnd_user usr, per_people_x per
770: where usr.user_id = p_user_id
771: and usr.employee_id = per.person_id(+);
772:
773: user_rec user_cur%ROWTYPE;