DBA Data[Home] [Help]

APPS.PER_PSO_BUS dependencies on PER_ORGANIZATION_UNITS

Line 32: , per_organization_units pou

28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_security_organizations pso
32: , per_organization_units pou
33: where pso.security_organization_id = p_security_organization_id
34: and pbg.business_group_id = pou.business_group_id
35: and pou.organization_id = pso.organization_id;
36: --

Line 98: , per_organization_units pou

94: cursor csr_leg_code is
95: select pbg.legislation_code
96: from per_business_groups pbg
97: , per_security_organizations pso
98: , per_organization_units pou
99: where pso.security_organization_id = p_security_organization_id
100: and pbg.business_group_id = pou.business_group_id
101: and pou.organization_id = pso.organization_id;
102: