APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 32: per_gen_hierarchy_nodes pgn

28: c_hierarchy_name, c_hierarchy_version_num, c_parent_org_id, c_parent_node_id
29: from
30: per_gen_hierarchy pgh,
31: per_gen_hierarchy_versions pgv,
32: per_gen_hierarchy_nodes pgn
33: where
34: pgh.hierarchy_id = p_hierarchy_id
35: and pgh.hierarchy_id = pgv.hierarchy_id
36: and pgv.hierarchy_version_id = p_hierarchy_version_id

Line 79: per_gen_hierarchy_nodes pgn,

75: select null
76: into l_dummy
77: from hr_location_extra_info hlei1,
78: hr_location_extra_info hlei2,
79: per_gen_hierarchy_nodes pgn,
80: hr_locations_all eloc
81: where pgn.hierarchy_version_id = p_hierarchy_version_id
82: and pgn.node_type = 'EST'
83: and eloc.location_id = pgn.entity_id

Line 165: from per_gen_hierarchy_nodes

161: and ass.primary_flag = 'Y'
162: and (ass.location_id is null
163: or ass.location_id not in
164: (select entity_id
165: from per_gen_hierarchy_nodes
166: where hierarchy_version_id = p_hierarchy_version_id
167: and node_type <> 'PAR'))
168: ;
169: cursor c_assignment is