eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on PER_ALL_PEOPLE_F

Line 20: from per_all_people_f

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
22: and trunc(sysdate) between effective_start_date and effective_end_date
23: );
24:

Line 69: ,per_all_people_f ppf

65: from irc_offers iof
66: ,per_all_vacancies vac
67: ,per_jobs_vl job
68: ,per_all_assignments_f asg
69: ,per_all_people_f ppf
70: ,irc_posting_contents_vl ipc
71: where
72: iof.offer_status = 'EXTENDED'
73: and iof.vacancy_id = vac.vacancy_id

Line 102: ,per_all_people_f ppf

98: from irc_offers iof
99: ,per_all_vacancies vac
100: ,per_jobs_vl job
101: ,per_all_assignments_f asg
102: ,per_all_people_f ppf
103: ,irc_posting_contents_vl ipc
104: where
105: iof.offer_status = 'CLOSED'
106: and iof.vacancy_id = vac.vacancy_id

Line 142: ,per_all_people_f ppf

138: from irc_offers iof
139: ,per_all_vacancies vac
140: ,per_jobs_vl job
141: ,per_all_assignments_f asg
142: ,per_all_people_f ppf
143: ,irc_posting_contents_vl ipc
144: where
145: iof.offer_status = 'EXTENDED'
146: and iof.latest_offer = 'Y'

Line 176: ,per_all_people_f ppf

172: from irc_offers iof
173: ,per_all_vacancies vac
174: ,per_jobs_vl job
175: ,per_all_assignments_f asg
176: ,per_all_people_f ppf
177: ,irc_posting_contents_vl ipc
178: where
179: iof.vacancy_id = vac.vacancy_id
180: and iof.offer_status = 'EXTENDED'

Line 204: ,per_all_people_f ppf

200: from irc_offers iof
201: ,per_all_vacancies vac
202: ,per_jobs_vl job
203: ,per_all_assignments_f asg
204: ,per_all_people_f ppf
205: where
206: iof.offer_status = 'HOLD'
207: and iof.vacancy_id = vac.vacancy_id
208: and vac.job_id = job.job_id(+)

Line 1998: from per_all_people_f ppf

1994: CURSOR csr_get_name
1995: (p_person_id IN number)
1996: IS
1997: select ppf.full_name
1998: from per_all_people_f ppf
1999: where ppf.person_id = p_person_id
2000: and sysdate between effective_start_date and effective_end_date;
2001: --
2002:

Line 2373: from per_all_people_f ppf

2369: CURSOR csr_get_name
2370: (p_person_id IN number)
2371: IS
2372: select ppf.full_name
2373: from per_all_people_f ppf
2374: where ppf.person_id = p_person_id
2375: and sysdate between effective_start_date and effective_end_date;
2376: --
2377: