APPS.IRC_PRIMARY_POSTING_CHANGE dependencies on PER_RECRUITMENT_ACTIVITIES

Line 27: from per_recruitment_activities per_rac

23: cursor get_dummy_posting(p_vacancy_id number) is
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

Line 54: delete from per_recruitment_activities

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:
57: end loop;
58: l_rows_processed := l_rows_processed + 1;