DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on HR_LOCATION_EXTRA_INFO

Line 1663: ,hr_location_extra_info hlei1

1659: select
1660: pghn1.hierarchy_node_id
1661: from
1662: per_gen_hierarchy_nodes pghn1
1663: ,hr_location_extra_info hlei1
1664: ,hr_location_extra_info hlei2
1665: ,hr_locations_all eloc
1666: where
1667: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID

Line 1664: ,hr_location_extra_info hlei2

1660: pghn1.hierarchy_node_id
1661: from
1662: per_gen_hierarchy_nodes pghn1
1663: ,hr_location_extra_info hlei1
1664: ,hr_location_extra_info hlei2
1665: ,hr_locations_all eloc
1666: where
1667: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
1668: and pghn1.node_type = 'EST'