APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on PER_JOBS_VL

Line 67: ,per_jobs_vl job

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

Line 100: ,per_jobs_vl job

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

Line 140: ,per_jobs_vl job

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

Line 174: ,per_jobs_vl job

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

Line 202: ,per_jobs_vl job

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