APPS.IRC_PRIMARY_POSTING_CHANGE dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 28: , per_recruitment_activity_for per_for

24: select per_rac.posting_content_id
25: , per_rac.recruitment_activity_id
26: , per_for.recruitment_activity_for_id
27: from per_recruitment_activities per_rac
28: , per_recruitment_activity_for per_for
29: where per_for.vacancy_id=p_vacancy_id
30: and per_for.recruitment_activity_id = per_rac.recruitment_activity_id
31: and per_rac.posting_content_id is not null
32: and per_rac.recruiting_site_id is null

Line 34: from per_recruitment_activity_for per_for2

30: and per_for.recruitment_activity_id = per_rac.recruitment_activity_id
31: and per_rac.posting_content_id is not null
32: and per_rac.recruiting_site_id is null
33: and not exists (select null
34: from per_recruitment_activity_for per_for2
35: where per_for2.recruitment_activity_id = per_for.recruitment_activity_id
36: and per_for2.vacancy_id <> per_for.vacancy_id)
37: order by per_rac.posting_content_id;
38: --

Line 52: delete from per_recruitment_activity_for

48: update per_all_assignments_f
49: set recruitment_activity_id = null
50: where recruitment_activity_id=posting_rec.recruitment_activity_id;
51:
52: delete from per_recruitment_activity_for
53: where recruitment_activity_for_id=posting_rec.recruitment_activity_for_id;
54: delete from per_recruitment_activities
55: where recruitment_activity_id=posting_rec.recruitment_activity_id;
56: