DBA Data[Home] [Help]

APPS.PER_VETS_MAG_REPORT dependencies on HR_LOCATION_EXTRA_INFO

Line 1057: hr_location_extra_info hlei1,

1053: hlei2.lei_information10 hq,
1054: eloc.location_id,
1055: pghn.hierarchy_node_id
1056: from per_gen_hierarchy_nodes pghn,
1057: hr_location_extra_info hlei1,
1058: hr_location_extra_info hlei2,
1059: hr_locations_all eloc
1060: where pghn.hierarchy_version_id = p_hierarchy_version_id
1061: and pghn.node_type = 'EST'

Line 1058: hr_location_extra_info hlei2,

1054: eloc.location_id,
1055: pghn.hierarchy_node_id
1056: from per_gen_hierarchy_nodes pghn,
1057: hr_location_extra_info hlei1,
1058: hr_location_extra_info hlei2,
1059: hr_locations_all eloc
1060: where pghn.hierarchy_version_id = p_hierarchy_version_id
1061: and pghn.node_type = 'EST'
1062: and eloc.location_id = pghn.entity_id