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
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
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