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 4390: FROM per_security_organizations

4386: --
4387: CURSOR csr_get_discrete_orgs IS
4388: SELECT organization_id
4389: ,entry_type
4390: FROM per_security_organizations
4391: WHERE p_security_profile_id IS NOT NULL
4392: AND security_profile_id = p_security_profile_id
4393: ORDER BY entry_type DESC;
4394:

Line 8397: DELETE FROM per_security_organizations pso

8393: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
8394:
8395: -- Bug fix 4889068.
8396: -- SQL Tuned to improve performance.
8397: DELETE FROM per_security_organizations pso
8398: WHERE EXISTS( SELECT null
8399: FROM hr_all_organization_units ou
8400: WHERE ou.business_group_id = p_business_group_id
8401: and ou.organization_id = pso.organization_id);