APPS.IRC_IOS_BUS dependencies on PER_ALL_VACANCIES

Line 31: , per_all_vacancies vac

27: cursor csr_leg_code is
28: select pbg.legislation_code
29: from per_business_groups_perf pbg
30: , irc_offer_status_history ios
31: , per_all_vacancies vac
32: where ios.offer_status_history_id = p_offer_status_history_id
33: and pbg.business_group_id = vac.business_group_id;
34: --
35: -- Declare local variables