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_LOCATIONS_ALL

Line 166: hr_locations_all loc

162: per_gen_hierarchy_nodes pgn,
163: hr_organization_units hou,
164: hr_organization_information hoi1,
165: hr_organization_information hoi2,
166: hr_locations_all loc
167: where pgn.hierarchy_version_id = p_hierarchy_version_id
168: and pgn.node_type = 'PAR'
169: and pgn.entity_id = hou.organization_id
170: and hoi1.org_information_context = 'VETS_Spec'

Line 202: hr_locations_all loc

198: hr_all_organization_units hou, -- vik
199: -- hr_organization_units hou, -- vik
200: hr_organization_information hoi1,
201: hr_organization_information hoi2,
202: hr_locations_all loc
203: where pgn.hierarchy_version_id = p_hierarchy_version_id
204: and pgn.node_type = 'PAR'
205: and pgn.entity_id = hou.organization_id
206: and pgn.business_group_id = p_business_group_id -- vik

Line 950: hr_locations_all eloc

946: pghn.hierarchy_node_id
947: from per_gen_hierarchy_nodes pghn,
948: hr_location_extra_info hlei1,
949: hr_location_extra_info hlei2,
950: hr_locations_all eloc
951: where pghn.hierarchy_version_id = p_hierarchy_version_id
952: and pghn.node_type = 'EST'
953: and eloc.location_id = pghn.entity_id
954: and hlei1.location_id = pghn.entity_id