DBA Data[Home] [Help]

APPS.PER_ORS_BUS dependencies on PER_BUSINESS_GROUPS

Line 304: from per_business_groups pbg

300: -- Declare cursor
301: --
302: cursor csr_sec_grp is
303: select pbg.security_group_id
304: from per_business_groups pbg
305: , per_organization_structures ors
306: where ors.organization_structure_id = p_organization_structure_id
307: and pbg.business_group_id = ors.business_group_id;
308: --

Line 365: from per_business_groups pbg

361: -- Declare cursor
362: --
363: cursor csr_leg_code is
364: select pbg.legislation_code
365: from per_business_groups pbg
366: , per_organization_structures ors
367: where ors.organization_structure_id = p_organization_structure_id
368: and pbg.business_group_id (+) = ors.business_group_id;
369: --