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_ORG_STRUCTURE_ELEMENTS_PKG dependencies on PER_SECURITY_PROFILES

Line 146: from per_security_profiles x

142: into l_sec_view_all_orgs_flag
143: , l_sec_org_structure_id
144: , l_sec_org_id
145: , l_sec_include_top_org_flag
146: from per_security_profiles x
147: where ( x.business_group_id + 0 = p_business_group_id
148: or x.business_group_id is null)
149: and x.security_profile_id = p_security_profile_id;
150: --

Line 239: from per_security_profiles psp

235: select null
236: into l_temp
237: from sys.dual
238: where exists( select null
239: from per_security_profiles psp
240: where psp.include_top_organization_flag = 'Y'
241: and psp.organization_structure_id =
242: (select osv.organization_structure_id
243: from per_org_structure_versions osv

Line 325: from per_security_profiles psp

321: );
322: --
323: cursor c2 is
324: select 'Y'
325: from per_security_profiles psp
326: , per_org_structure_versions posv
327: where ( psp.business_group_id =p_business_group_id
328: or ( psp.business_group_id is null
329: and p_business_group_id is null))