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

Line 157: FROM hr_organization_information hoi

153: (SELECT hoi.organization_id organization_id,
154: NVL(to_number(hoi.org_information2), -1) manager_person_id ,
155: NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,
156: NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time) end_date
157: FROM hr_organization_information hoi
158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL
160: AND EXISTS ( SELECT NULL
161: FROM hr_org_info_types_by_class oitbc,

Line 162: hr_organization_information org_info

158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL
160: AND EXISTS ( SELECT NULL
161: FROM hr_org_info_types_by_class oitbc,
162: hr_organization_information org_info
163: WHERE org_info.organization_id = hoi.organization_id
164: AND org_info.org_information_context = 'CLASS'
165: AND org_info.org_information2 = 'Y'
166: AND oitbc.org_classification = org_info.org_information1