APPS.IRC_MRS_UPGRADE dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 19: l_rec_activity_for_id per_recruitment_activity_for.recruitment_activity_for_id%type;

15: l_external_site_id irc_all_recruiting_sites.recruiting_site_id%type;
16: l_api_ovn per_recruitment_activities.object_version_number%type;
17: l_int_ext_rec_id per_recruitment_activities.recruitment_activity_id%type;
18: l_third_rec_id per_recruitment_activities.recruitment_activity_id%type;
19: l_rec_activity_for_id per_recruitment_activity_for.recruitment_activity_for_id%type;
20: l_raa_id number;
21: l_vac_name per_all_vacancies.name%type;
22: l_ovn number;
23: l_rows_processed number := 0;

Line 53: from per_recruitment_activity_for pfr

49: --
50: cursor csr_rec_activity_for(p_recruitment_activity_id number) is
51: select pfr.business_group_id business_group_id
52: ,pfr.vacancy_id vacancy_id
53: from per_recruitment_activity_for pfr
54: where pfr.recruitment_activity_id = p_recruitment_activity_id;
55: --
56: -- This cursor gets all assignments in which a person has applied for a recruitment activity
57: -- and looks to see is the person is an emp-apl

Line 99: ,per_recruitment_activity_for raf

95: --
96: cursor dup_ints is
97: select raa.recruitment_activity_id
98: from per_recruitment_activities raa
99: ,per_recruitment_activity_for raf
100: where raa.posting_content_id is not null
101: and raa.internal_posting='Y'
102: and raa.recruitment_activity_id=raf.recruitment_activity_id
103: and exists (select 1

Line 104: from per_recruitment_activity_for raf2

100: where raa.posting_content_id is not null
101: and raa.internal_posting='Y'
102: and raa.recruitment_activity_id=raf.recruitment_activity_id
103: and exists (select 1
104: from per_recruitment_activity_for raf2
105: ,per_recruitment_activities raa2
106: where raf2.vacancy_id=raf.vacancy_id
107: and raf2.recruitment_activity_id=raa2.recruitment_activity_id
108: and raa2.internal_posting='Y'

Line 116: ,per_recruitment_activity_for raf

112: --
113: cursor dup_exts is
114: select raa.recruitment_activity_id
115: from per_recruitment_activities raa
116: ,per_recruitment_activity_for raf
117: where raa.posting_content_id is not null
118: and raa.external_posting='Y'
119: and raa.recruitment_activity_id=raf.recruitment_activity_id
120: and exists (select 1

Line 121: from per_recruitment_activity_for raf2

117: where raa.posting_content_id is not null
118: and raa.external_posting='Y'
119: and raa.recruitment_activity_id=raf.recruitment_activity_id
120: and exists (select 1
121: from per_recruitment_activity_for raf2
122: ,per_recruitment_activities raa2
123: where raf2.vacancy_id=raf.vacancy_id
124: and raf2.recruitment_activity_id=raa2.recruitment_activity_id
125: and raa2.external_posting='Y'