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.HR_SECURITY_INTERNAL dependencies on PER_SECURITY_ORGANIZATIONS

Line 4499: FROM per_security_organizations

4495: --
4496: CURSOR csr_get_discrete_orgs IS
4497: SELECT organization_id
4498: ,entry_type
4499: FROM per_security_organizations
4500: WHERE p_security_profile_id IS NOT NULL
4501: AND security_profile_id = p_security_profile_id
4502: ORDER BY entry_type DESC;
4503:

Line 9261: DELETE FROM per_security_organizations pso

9257: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
9258:
9259: -- Bug fix 4889068.
9260: -- SQL Tuned to improve performance.
9261: DELETE FROM per_security_organizations pso
9262: WHERE EXISTS( SELECT null
9263: FROM hr_all_organization_units ou
9264: WHERE ou.business_group_id = p_business_group_id
9265: and ou.organization_id = pso.organization_id);