DBA Data[Home] [Help]

APPS.IRC_IOF_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups pbg

26: -- Declare cursor
27: --
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

Line 94: from per_business_groups_perf pbg

90: -- Declare cursor
91: --
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