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 181: from hr_organization_information hoi1

177:
178: and ass.assignment_type = 'E'
179: and ass.primary_flag = 'Y'
180: and exists (select 'x'
181: from hr_organization_information hoi1
182: where to_char(ass.assignment_status_type_id) = hoi1.org_information1
183: and hoi1.org_information_context = 'Reporting Statuses'
184: and hoi1.organization_id = P_BUSINESS_GROUP_ID);
185: cursor c_ethnic is

Line 219: from hr_organization_information hoi2

215: and ass.assignment_type = 'E'
216: and ass.primary_flag = 'Y'
217: and ass.employment_category is not null
218: and exists (select 'x'
219: from hr_organization_information hoi2
220: where ass.employment_category = hoi2.org_information1
221: and hoi2.org_information_context = 'Reporting Categories'
222: and hoi2.organization_id = P_BUSINESS_GROUP_ID);
223: cursor c_job_category is