44: select
45: pgh.name, pgv.version_number, pgn.entity_id, pgn.hierarchy_node_id
46: from
47: per_gen_hierarchy pgh,
48: per_gen_hierarchy_versions pgv,
49: per_gen_hierarchy_nodes pgn
50: where
51: pgh.hierarchy_id = p_hierarchy_id
52: and pgh.hierarchy_id = pgv.hierarchy_id
104:
105: l_business_group_name varchar2(240); --Increased variable size for Bug#9038285
106: c_date_end date;
107: l_hierarchy_name per_gen_hierarchy.name%type;
108: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
109: l_parent_org_id varchar2(20);
110: l_parent_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
112: l_est_no number;