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: and (usr.end_date is null or usr.end_date >=sysdate);
17: --
18: BEGIN

Line 226: from fnd_user

222: l_user_name wf_users.name%TYPE ;
223: l_nid number;
224: cursor get_user_name is
225: select user_name
226: from fnd_user
227: where upper(email_address)=upper(p_email_address)
228: and (end_date is null or end_date >=sysdate);
229:
230: BEGIN