APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_GEN_HIERARCHY

Line 30: per_gen_hierarchy pgh,

26: pgh.name, pgv.version_number, pgn.entity_id, pgn.hierarchy_node_id
27: into
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

Line 31: per_gen_hierarchy_versions pgv,

27: into
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

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 170: from per_gen_hierarchy_nodes

166: and ass.primary_flag = 'Y'
167: and (ass.location_id is null
168: or ass.location_id not in
169: (select entity_id
170: from per_gen_hierarchy_nodes
171: where hierarchy_version_id = p_hierarchy_version_id
172: and node_type <> 'PAR'))
173: ;
174: