DBA Data[Home] [Help]

APPS.BEN_OTP_BUS dependencies on PER_BUSINESS_GROUPS

Line 162: from per_business_groups pbg

158: -- Declare cursor
159: --
160: cursor csr_sec_grp is
161: select pbg.security_group_id
162: from per_business_groups pbg
163: , ben_optip_f otp
164: where otp.optip_id = p_optip_id
165: and pbg.business_group_id = otp.business_group_id;
166: --

Line 224: from per_business_groups pbg

220: -- Declare cursor
221: --
222: cursor csr_leg_code is
223: select pbg.legislation_code
224: from per_business_groups pbg
225: , ben_optip_f otp
226: where otp.optip_id = p_optip_id
227: and pbg.business_group_id = otp.business_group_id;
228: --