DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on PER_BUSINESS_GROUPS

Line 103: from per_business_groups pbg

99: -- Declare cursor
100: --
101: cursor csr_sec_grp is
102: select pbg.security_group_id
103: from per_business_groups pbg
104: , per_previous_employers pem
105: where pem.previous_employer_id = p_previous_employer_id
106: and pbg.business_group_id = pem.business_group_id;
107: --

Line 165: from per_business_groups pbg

161: -- Declare cursor
162: --
163: cursor csr_leg_code is
164: select pbg.legislation_code
165: from per_business_groups pbg
166: , per_previous_employers pem
167: where pem.previous_employer_id = p_previous_employer_id
168: and pbg.business_group_id (+) = pem.business_group_id;
169: --