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_VACANCY_CONSIDERATIONS_API dependencies on PER_RECRUITMENT_ACTIVITIES

Line 91: , per_recruitment_activities ra

87: , pctl.job_title
88: , pctl.posting_content_id
89: , pctl.name
90: from per_recruitment_activity_for raf
91: , per_recruitment_activities ra
92: , irc_posting_contents_tl pctl
93: where raf.vacancy_id = p_vacancy_id
94: and raf.recruitment_activity_id = ra.recruitment_activity_id
95: and ra.posting_content_id = pctl.posting_content_id

Line 245: , per_recruitment_activities ra

241: , pctl.job_title
242: , pctl.posting_content_id
243: , pctl.name
244: from per_recruitment_activity_for raf
245: , per_recruitment_activities ra
246: , irc_posting_contents_tl pctl
247: where raf.vacancy_id = p_vacancy_id
248: and raf.recruitment_activity_id = ra.recruitment_activity_id
249: and ra.posting_content_id = pctl.posting_content_id

Line 382: , per_recruitment_activities ra

378: --
379: cursor c_posting_details is
380: select null
381: from per_recruitment_activity_for raf
382: , per_recruitment_activities ra
383: , irc_posting_contents_tl pctl
384: where raf.vacancy_id = p_vacancy_id
385: and raf.recruitment_activity_id = ra.recruitment_activity_id
386: and ra.posting_content_id = pctl.posting_content_id