DBA Data[Home] [Help]

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 207: fnd_user usr

203: IS
204: select
205: usr.user_name
206: from
207: fnd_user usr
208: where usr.user_id = p_user_id;
209:
210: -- ----------------------------------------------------------------------------
211: -- FUNCTIONS