APPS.IRC_IOF_BUS dependencies on PER_ALL_VACANCIES

Line 32: , per_all_vacancies vac

28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , irc_offers iof
32: , per_all_vacancies vac
33: where iof.offer_id = p_offer_id
34: and vac.vacancy_id = iof.vacancy_id
35: and pbg.business_group_id = vac.business_group_id;
36: --

Line 96: , per_all_vacancies vac

92: cursor csr_leg_code is
93: select pbg.legislation_code
94: from per_business_groups_perf pbg
95: , irc_offers iof
96: , per_all_vacancies vac
97: where iof.offer_id = p_offer_id
98: and iof.vacancy_id = vac.vacancy_id
99: and pbg.business_group_id = vac.business_group_id;
100: --

Line 735: from per_all_vacancies

731: --
732: cursor csr_vacancy_opening_count is
733: select budget_measurement_value
734: ,budget_measurement_type
735: from per_all_vacancies
736: where vacancy_id = p_vacancy_id;
737: --
738: cursor csr_prev_to_prev_offer_chg_rsn is
739: select ios1.offer_status

Line 770: ,per_all_vacancies pav

766: --
767: cursor csr_offer_count is
768: select count(*)
769: from irc_offers iof
770: ,per_all_vacancies pav
771: ,irc_offer_status_history iosh
772: where pav.vacancy_id = p_vacancy_id
773: and iof.vacancy_id = pav.vacancy_id
774: and iosh.offer_id = iof.offer_id