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 66: ,per_all_people_f ppf

62: from irc_offers iof
63: ,per_all_vacancies vac
64: ,per_jobs_vl job
65: ,per_all_assignments_f asg
66: ,per_all_people_f ppf
67: where
68: iof.offer_status = 'EXTENDED'
69: and iof.vacancy_id = vac.vacancy_id
70: and vac.job_id = job.job_id(+)

Line 96: ,per_all_people_f ppf

92: from irc_offers iof
93: ,per_all_vacancies vac
94: ,per_jobs_vl job
95: ,per_all_assignments_f asg
96: ,per_all_people_f ppf
97: ,irc_posting_contents_vl ipc
98: where
99: iof.offer_status = 'CLOSED'
100: and iof.vacancy_id = vac.vacancy_id

Line 134: ,per_all_people_f ppf

130: from irc_offers iof
131: ,per_all_vacancies vac
132: ,per_jobs_vl job
133: ,per_all_assignments_f asg
134: ,per_all_people_f ppf
135: where
136: iof.offer_status = 'EXTENDED'
137: and iof.latest_offer = 'Y'
138: and iof.vacancy_id = vac.vacancy_id

Line 164: ,per_all_people_f ppf

160: from irc_offers iof
161: ,per_all_vacancies vac
162: ,per_jobs_vl job
163: ,per_all_assignments_f asg
164: ,per_all_people_f ppf
165: where
166: iof.vacancy_id = vac.vacancy_id
167: and iof.offer_status = 'EXTENDED'
168: and iof.latest_offer = 'Y'

Line 190: ,per_all_people_f ppf

186: from irc_offers iof
187: ,per_all_vacancies vac
188: ,per_jobs_vl job
189: ,per_all_assignments_f asg
190: ,per_all_people_f ppf
191: where
192: iof.offer_status = 'HOLD'
193: and iof.vacancy_id = vac.vacancy_id
194: and vac.job_id = job.job_id(+)

Line 1377: from per_all_people_f ppf

1373: CURSOR csr_get_name
1374: (p_person_id IN number)
1375: IS
1376: select ppf.full_name
1377: from per_all_people_f ppf
1378: where ppf.person_id = p_person_id
1379: and sysdate between effective_start_date and effective_end_date;
1380: --
1381:

Line 1683: from per_all_people_f ppf

1679: CURSOR csr_get_name
1680: (p_person_id IN number)
1681: IS
1682: select ppf.full_name
1683: from per_all_people_f ppf
1684: where ppf.person_id = p_person_id
1685: and sysdate between effective_start_date and effective_end_date;
1686: --
1687: