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_VETS_MAG_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 178: hr_organization_units hou,

174: hoi2.org_information4 duns,
175: hoi2.org_information3 ein
176: from --per_gen_hierarchy_nodes pghn,
177: per_gen_hierarchy_nodes pgn,
178: hr_organization_units hou,
179: hr_organization_information hoi1,
180: hr_organization_information hoi2,
181: hr_locations_all loc
182: where pgn.hierarchy_version_id = p_hierarchy_version_id

Line 213: -- hr_organization_units hou, -- vik

209: upper(replace(replace(hoi2.org_information4,'-',''),',','')) duns, --bug 13905482
210: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --bug 13905482
211: from per_gen_hierarchy_nodes pgn,
212: hr_all_organization_units hou, -- vik
213: -- hr_organization_units hou, -- vik
214: hr_organization_information hoi1,
215: hr_organization_information hoi2,
216: hr_locations_all loc
217: where pgn.hierarchy_version_id = p_hierarchy_version_id

Line 240: ,hr_organization_units hou

236: ,upper(replace(hoi2.org_information20,',',' ')) contact_email
237: from
238: hr_organization_information hoi1
239: ,hr_locations_all cloc
240: ,hr_organization_units hou
241: ,hr_organization_information hoi2
242: ,per_gen_hierarchy_nodes pgn
243: where
244: hoi1.organization_id = pgn.entity_id