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 49: , per_recruitment_activities ra

45: , pctl.job_title
46: , pctl.posting_content_id
47: , pctl.name
48: from per_recruitment_activity_for raf
49: , per_recruitment_activities ra
50: , irc_posting_contents_tl pctl
51: where raf.vacancy_id = p_vacancy_id
52: and raf.recruitment_activity_id = ra.recruitment_activity_id
53: and ra.posting_content_id = pctl.posting_content_id

Line 206: , per_recruitment_activities ra

202: , pctl.job_title
203: , pctl.posting_content_id
204: , pctl.name
205: from per_recruitment_activity_for raf
206: , per_recruitment_activities ra
207: , irc_posting_contents_tl pctl
208: where raf.vacancy_id = p_vacancy_id
209: and raf.recruitment_activity_id = ra.recruitment_activity_id
210: and ra.posting_content_id = pctl.posting_content_id

Line 345: , per_recruitment_activities ra

341: --
342: cursor c_posting_details is
343: select null
344: from per_recruitment_activity_for raf
345: , per_recruitment_activities ra
346: , irc_posting_contents_tl pctl
347: where raf.vacancy_id = p_vacancy_id
348: and raf.recruitment_activity_id = ra.recruitment_activity_id
349: and ra.posting_content_id = pctl.posting_content_id