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 63: ,per_all_vacancies vac

59: ,asg.person_id as applicant_id
60: ,ppf.full_name as applicant_name
61: ,iof.created_by as creator_id
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

Line 93: ,per_all_vacancies vac

89: ,ppf.full_name as applicant_name
90: ,ipc.name as job_posting_title
91: ,iof.last_updated_by as last_updated
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

Line 131: ,per_all_vacancies vac

127: ,ppf.full_name as applicant_name
128: ,iof.expiry_date
129: ,iof.created_by as creator_id
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

Line 161: ,per_all_vacancies vac

157: ,asg.person_id as applicant_id
158: ,ppf.full_name as applicant_name
159: ,iof.created_by as creator_id
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

Line 187: ,per_all_vacancies vac

183: ,iof.created_by as creator_id
184: ,job.name as job_title
185: ,ppf.full_name as applicant_name
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