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 756: ,per_all_vacancies pav

752: --
753: cursor csr_offer_count is
754: select count(*)
755: from irc_offers iof
756: ,per_all_vacancies pav
757: ,irc_offer_status_history iosh
758: where pav.vacancy_id = p_vacancy_id
759: and iof.vacancy_id = pav.vacancy_id
760: and iosh.offer_status_history_id = (select max(offer_status_history_id) from irc_offer_status_history where offer_id = iof.offer_id)