DBA Data[Home] [Help]

APPS.PER_EEO_MAG_REPORT dependencies on HR_LOCATIONS_ALL

Line 1912: hr_locations_all eloc

1908: hlei2.lei_information10 hq
1909: FROM per_gen_hierarchy_nodes pghn,
1910: hr_location_extra_info hlei1,
1911: hr_location_extra_info hlei2,
1912: hr_locations_all eloc
1913: WHERE -- pghn.hierarchy_version_id = 2683 -- sd1
1914: pghn.hierarchy_version_id = p_hierarchy_version_id -- 2803 sd10plus
1915: -- pghn.hierarchy_version_id = 2823 -- Vik SD Albuquereque
1916: AND pghn.node_type = 'EST'

Line 2374: hr_locations_all eloc

2370: eloc.location_code
2371: INTO l_location_id,
2372: l_location_code
2373: FROM per_gen_hierarchy_nodes pgn,
2374: hr_locations_all eloc
2375: WHERE (hierarchy_node_id = p_hierarchy_node_id
2376: or parent_hierarchy_node_id = p_hierarchy_node_id)
2377: AND hierarchy_version_id = p_hierarchy_version_id
2378: AND pgn.node_type = 'EST'