DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 48: from per_recruitment_activity_for raf

44: select pctl.brief_description
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

Line 205: from per_recruitment_activity_for raf

201: select pctl.brief_description
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

Line 344: from per_recruitment_activity_for raf

340: l_rec_found varchar2(1);
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