DBA Data[Home] [Help]

APPS.PER_VAC_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_all_vacancies vac
31: where vac.vacancy_id = p_vacancy_id
32: and pbg.business_group_id = vac.business_group_id;
33: --

Line 91: from per_business_groups pbg

87: -- Declare cursor
88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , per_all_vacancies vac
93: where vac.vacancy_id = p_vacancy_id
94: and pbg.business_group_id = vac.business_group_id;
95: --