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_JOBS_VL

Line 64: ,per_jobs_vl job

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
68: iof.offer_status = 'EXTENDED'

Line 94: ,per_jobs_vl job

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
98: where

Line 132: ,per_jobs_vl job

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
136: iof.offer_status = 'EXTENDED'

Line 162: ,per_jobs_vl job

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
166: iof.vacancy_id = vac.vacancy_id

Line 188: ,per_jobs_vl job

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
192: iof.offer_status = 'HOLD'