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.

[Home] [Help]

APPS.IRC_NOTIFICATION_DATA_PKG dependencies on IRC_POSTING_CONTENTS_VL

Line 213: irc_posting_contents_vl ipc

209: from per_all_vacancies pav,
210: per_jobs pj,
211: hr_all_positions_f pp,
212: per_recruitment_activities pra,
213: irc_posting_contents_vl ipc
214: where vacancy_id = c_vacancyId
215: and pav.job_id = pj.job_id(+)
216: and pav.position_id = pp.position_id(+)
217: and trunc(c_effectiveDate) between trunc(pav.date_from)