APPS.IRC_PRIMARY_POSTING_CHANGE dependencies on PER_ALL_VACANCIES

Line 17: select per_vac.vacancy_id from per_all_vacancies per_vac

13: --
14: -- This cursor gets all of the vacancy records to be processed
15: --
16: cursor get_vacs is
17: select per_vac.vacancy_id from per_all_vacancies per_vac
18: where per_vac.vacancy_id between p_start_pkid and p_end_pkid
19: and per_vac.primary_posting_id is null;
20: --
21: -- this cursor gets all of the dummy recruitment activity records

Line 44: update per_all_vacancies

40: --
41: begin
42: for vac_rec in get_vacs loop
43: for posting_rec in get_dummy_posting(vac_rec.vacancy_id) loop
44: update per_all_vacancies
45: set primary_posting_id=posting_rec.posting_content_id
46: where vacancy_id=vac_rec.vacancy_id;
47:
48: update per_all_assignments_f