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.AMW_WF_HIERARCHY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2612: from hr_organization_information

2608:
2609: begin
2610: select org_information2
2611: into l_dummy
2612: from hr_organization_information
2613: where organization_id in (select distinct organization_id from amw_audit_units_v)
2614: and org_information_context = 'Organization Name Alias'
2615: and org_information2 = l_empid;
2616: exception

Line 2627: from hr_organization_information

2623:
2624: begin
2625: select 1
2626: into l_dummy
2627: from hr_organization_information
2628: where organization_id = p_org_id
2629: and org_information_context = 'Organization Name Alias'
2630: and org_information2 = l_empid;
2631:

Line 2651: from hr_organization_information hoi, amw_audit_units_v aauv

2647: hier_name varchar2(30);
2648:
2649: cursor c_orgs(l_emp number) is
2650: select hoi.organization_id
2651: from hr_organization_information hoi, amw_audit_units_v aauv
2652: where hoi.organization_id = aauv.organization_id
2653: and hoi.org_information_context = 'Organization Name Alias'
2654: and hoi.org_information2 = l_emp;
2655: