DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on PER_GEN_HIERARCHY_NODES

Line 1680: per_gen_hierarchy_nodes pghn1

1676: cursor c_est_entity is
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

Line 1704: per_gen_hierarchy_nodes pgn

1700: cursor c_tot_emps is
1701: select count('ass')
1702: from
1703: per_all_assignments_f ass,
1704: per_gen_hierarchy_nodes pgn
1705: where
1706: ass.business_group_id = P_BUSINESS_GROUP_ID
1707: and ass.assignment_type = 'E'
1708: and ass.primary_flag = 'Y'