APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on IRC_POSTING_CONTENTS_VL

Line 70: ,irc_posting_contents_vl ipc

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
72: iof.offer_status = 'EXTENDED'
73: and iof.vacancy_id = vac.vacancy_id
74: and vac.job_id = job.job_id(+)

Line 103: ,irc_posting_contents_vl ipc

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
105: iof.offer_status = 'CLOSED'
106: and iof.vacancy_id = vac.vacancy_id
107: and vac.job_id = job.job_id(+)

Line 143: ,irc_posting_contents_vl ipc

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
145: iof.offer_status = 'EXTENDED'
146: and iof.latest_offer = 'Y'
147: and iof.vacancy_id = vac.vacancy_id

Line 177: ,irc_posting_contents_vl ipc

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
179: iof.vacancy_id = vac.vacancy_id
180: and iof.offer_status = 'EXTENDED'
181: and iof.latest_offer = 'Y'