DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on PER_PEOPLE_X

Line 744: | with per_people_x

740: | MODIFICATION HISTORY
741: | Date Author Description of Changes
742: | 25-May-2002 J Rautiainen Created
743: | 19-Aug-2004 skoukunt 3838623:replace per_workforce_x
744: | with per_people_x
745: |
746: *=======================================================================*/
747: FUNCTION get_employee_name(p_user_id IN NUMBER) RETURN VARCHAR2 IS
748:

Line 758: from fnd_user usr, per_people_x per

754: CURSOR user_cur IS
755: select DECODE(per.PERSON_ID,
756: null, usr.USER_NAME,
757: per.full_name) employee_name
758: from fnd_user usr, per_people_x per
759: where usr.user_id = p_user_id
760: and usr.employee_id = per.person_id(+);
761:
762: user_rec user_cur%ROWTYPE;