APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on FND_USER

Line 10: l_role_name fnd_user.user_name%type;

6: -- --------------------------------------------------------------------- *
7: FUNCTION get_job_seekers_role
8: (p_person_id per_all_people_f.person_id%type
9: ) RETURN varchar2 IS
10: l_role_name fnd_user.user_name%type;
11: --
12: cursor get_usr is
13: SELECT usr.user_name
14: FROM fnd_user usr

Line 14: FROM fnd_user usr

10: l_role_name fnd_user.user_name%type;
11: --
12: cursor get_usr is
13: SELECT usr.user_name
14: FROM fnd_user usr
15: WHERE usr.employee_id = p_person_id;
16: --
17: BEGIN
18: open get_usr;

Line 223: from fnd_user

219: l_user_name wf_users.name%TYPE ;
220: l_nid number;
221: cursor get_user_name is
222: select user_name
223: from fnd_user
224: where upper(email_address)=upper(p_email_address);
225:
226: BEGIN
227: