APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_USER

Line 17: fnd_user fnd

13: IS
14: select
15: fnd.employee_id as applicant_id
16: from
17: fnd_user fnd
18: where fnd.person_party_id in
19: (select party_id
20: from per_all_people_f
21: where person_id = p_person_id

Line 35: fnd_user usr

31: IS
32: select
33: usr.employee_id
34: from
35: fnd_user usr
36: where usr.user_id = p_user_id;
37:
38: -- ***************************************************************************
39: -- Cursor to get offer sent date

Line 221: fnd_user usr

217: IS
218: select
219: usr.user_name
220: from
221: fnd_user usr
222: where usr.user_id = p_user_id;
223: --
224: cursor csr_get_apl_assignment_id (p_offer_id in number) is
225: select applicant_assignment_id

Line 236: from fnd_user usr

232: where language_code = p_dft_lang;
233: --
234: cursor get_user_lang(l_applicant_id number) is
235: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
236: from fnd_user usr
237: where EMPLOYEE_ID = l_applicant_id;
238: -- ----------------------------------------------------------------------------
239: -- FUNCTIONS
240: -- ----------------------------------------------------------------------------