DBA Data[Home] [Help]

APPS.PER_VETS_MAG_100A_REPORT dependencies on HR_LOCATION_EXTRA_INFO

Line 1181: hr_location_extra_info hlei1,

1177: hlei2.lei_information10 hq,
1178: eloc.location_id,
1179: pghn.hierarchy_node_id
1180: from per_gen_hierarchy_nodes pghn,
1181: hr_location_extra_info hlei1,
1182: hr_location_extra_info hlei2,
1183: hr_locations_all eloc
1184: where pghn.hierarchy_version_id = p_hierarchy_version_id
1185: and pghn.node_type = 'EST'

Line 1182: hr_location_extra_info hlei2,

1178: eloc.location_id,
1179: pghn.hierarchy_node_id
1180: from per_gen_hierarchy_nodes pghn,
1181: hr_location_extra_info hlei1,
1182: hr_location_extra_info hlei2,
1183: hr_locations_all eloc
1184: where pghn.hierarchy_version_id = p_hierarchy_version_id
1185: and pghn.node_type = 'EST'
1186: and eloc.location_id = pghn.entity_id