DBA Data[Home] [Help]

APPS.IRC_VCE_BUS dependencies on PER_BUSINESS_GROUPS

Line 32: from per_business_groups pbg

28: -- Declare cursor
29: --
30: cursor csr_sec_grp is
31: select pbg.security_group_id
32: from per_business_groups pbg
33: , per_all_vacancies pav
34: where pav.vacancy_id = p_vacancy_id
35: and pbg.business_group_id = pav.business_group_id;
36: --

Line 103: -- Join between irc_variable_comp_elements and PER_BUSINESS_GROUPS

99: Return Varchar2 Is
100: --
101: -- Declare cursor
102: --
103: -- Join between irc_variable_comp_elements and PER_BUSINESS_GROUPS
104: -- so that the legislation_code for
105: -- the current business group context can be derived.
106:
107: cursor csr_leg_code is

Line 109: from per_business_groups pbg

105: -- the current business group context can be derived.
106:
107: cursor csr_leg_code is
108: select pbg.legislation_code
109: from per_business_groups pbg
110: ,per_all_vacancies pav
111: where pav.vacancy_id = p_vacancy_id
112: and pbg.business_group_id = pav.business_group_id;
113: --