DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on HR_LOCATION_EXTRA_INFO

Line 1681: ,hr_location_extra_info hlei1

1677: select
1678: pghn1.hierarchy_node_id
1679: from
1680: per_gen_hierarchy_nodes pghn1
1681: ,hr_location_extra_info hlei1
1682: ,hr_location_extra_info hlei2
1683: ,hr_locations_all eloc
1684: where
1685: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID

Line 1682: ,hr_location_extra_info hlei2

1678: pghn1.hierarchy_node_id
1679: from
1680: per_gen_hierarchy_nodes pghn1
1681: ,hr_location_extra_info hlei1
1682: ,hr_location_extra_info hlei2
1683: ,hr_locations_all eloc
1684: where
1685: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
1686: and pghn1.node_type = 'EST'