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_PERUSEOX_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 64: from hr_organization_information

60: end;
61: begin
62: select null
63: into l_dummy
64: from hr_organization_information
65: where organization_id = c_parent_org_id
66: and org_information_context = 'EEO_Spec';
67: exception
68: when no_data_found then

Line 187: from hr_organization_information hoi1

183:
184: and ass.assignment_type = 'E'
185: and ass.primary_flag = 'Y'
186: and exists (select 'x'
187: from hr_organization_information hoi1
188: where to_char(ass.assignment_status_type_id) = hoi1.org_information1
189: and hoi1.org_information_context = 'Reporting Statuses'
190: and hoi1.organization_id = P_BUSINESS_GROUP_ID);
191:

Line 229: from hr_organization_information hoi2

225: and ass.assignment_type = 'E'
226: and ass.primary_flag = 'Y'
227: and ass.employment_category is not null
228: and exists (select 'x'
229: from hr_organization_information hoi2
230: where ass.employment_category = hoi2.org_information1
231: and hoi2.org_information_context = 'Reporting Categories'
232: and hoi2.organization_id = P_BUSINESS_GROUP_ID);
233: