DBA Data[Home] [Help]

APPS.PER_OSV_BUS dependencies on PER_BUSINESS_GROUPS

Line 336: from per_business_groups pbg

332: -- Declare cursor
333: --
334: cursor csr_sec_grp is
335: select pbg.security_group_id
336: from per_business_groups pbg
337: , per_org_structure_versions osv
338: where osv.org_structure_version_id = p_org_structure_version_id
339: and pbg.business_group_id = osv.business_group_id;
340: --

Line 396: from per_business_groups pbg

392: -- Declare cursor
393: --
394: cursor csr_leg_code is
395: select pbg.legislation_code
396: from per_business_groups pbg
397: , per_org_structure_versions osv
398: where osv.org_structure_version_id = p_org_structure_version_id
399: and pbg.business_group_id (+) = osv.business_group_id;
400: --