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_ASSIGNMENTS_F

Line 65: ,per_all_assignments_f asg

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'
69: and iof.vacancy_id = vac.vacancy_id

Line 95: ,per_all_assignments_f asg

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
99: iof.offer_status = 'CLOSED'

Line 133: ,per_all_assignments_f asg

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'
137: and iof.latest_offer = 'Y'

Line 163: ,per_all_assignments_f asg

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

Line 189: ,per_all_assignments_f asg

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'
193: and iof.vacancy_id = vac.vacancy_id