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_VACANCIES

Line 66: ,per_all_vacancies vac

62: ,iof.created_by as creator_id
63: ,ipc.name as job_posting_title
64: ,ipc.job_title as ipc_job_title
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

Line 99: ,per_all_vacancies vac

95: ,ipc.name as job_posting_title
96: ,ipc.job_title as ipc_job_title
97: ,iof.last_updated_by as last_updated
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

Line 139: ,per_all_vacancies vac

135: ,iof.created_by as creator_id
136: ,ipc.name as job_posting_title
137: ,ipc.job_title as ipc_job_title
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

Line 173: ,per_all_vacancies vac

169: ,iof.created_by as creator_id
170: ,ipc.name as job_posting_title
171: ,ipc.job_title as ipc_job_title
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

Line 201: ,per_all_vacancies vac

197: ,iof.created_by as creator_id
198: ,job.name as job_title
199: ,ppf.full_name as applicant_name
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