DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on PER_GEN_HIERARCHY_NODES

Line 1662: per_gen_hierarchy_nodes pghn1

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

Line 1686: per_gen_hierarchy_nodes pgn

1682: cursor c_tot_emps is
1683: select count('ass')
1684: from
1685: per_all_assignments_f ass,
1686: per_gen_hierarchy_nodes pgn
1687: where
1688: ass.business_group_id = P_BUSINESS_GROUP_ID
1689: and ass.assignment_type = 'E'
1690: and ass.primary_flag = 'Y'