DBA Data[Home] [Help]

APPS.PER_EEO_MAG_REPORT dependencies on HR_LOCATIONS_ALL

Line 1879: hr_locations_all eloc

1875: hlei2.lei_information10 hq
1876: FROM per_gen_hierarchy_nodes pghn,
1877: hr_location_extra_info hlei1,
1878: hr_location_extra_info hlei2,
1879: hr_locations_all eloc
1880: WHERE -- pghn.hierarchy_version_id = 2683 -- sd1
1881: pghn.hierarchy_version_id = p_hierarchy_version_id -- 2803 sd10plus
1882: -- pghn.hierarchy_version_id = 2823 -- Vik SD Albuquereque
1883: AND pghn.node_type = 'EST'

Line 2241: hr_locations_all eloc

2237: eloc.location_code
2238: INTO l_location_id,
2239: l_location_code
2240: FROM per_gen_hierarchy_nodes pgn,
2241: hr_locations_all eloc
2242: WHERE (hierarchy_node_id = p_hierarchy_node_id
2243: or parent_hierarchy_node_id = p_hierarchy_node_id)
2244: AND hierarchy_version_id = p_hierarchy_version_id
2245: AND pgn.node_type = 'EST'