eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PSO_BUS dependencies on PER_SECURITY_ORGANIZATIONS

Line 31: , per_security_organizations pso

27:
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;

Line 97: , per_security_organizations pso

93: --
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;

Line 173: select null from per_Security_organizations

169: select null from hr_all_organization_units
170: where organization_id = p_rec.organization_id;
171:
172: cursor csr_unique is
173: select null from per_Security_organizations
174: where organization_id = p_rec.organization_id
175: and security_profile_id = p_rec.security_profile_id
176: and (p_rec.security_organization_id is null or security_organization_id <> p_rec.security_organization_id);
177: