APPS.GHG_TRANSACTIONS_API_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 1246: from (select * from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id )

1242: cursor node_members_treewalk (p_version_id number) is
1243: select *
1244: from (
1245: select level lvl, parent_hierarchy_node_id, hierarchy_node_id, node_type, entity_id
1246: from (select * from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id )
1247: start with hierarchy_node_id IN (select hierarchy_node_id from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id and parent_hierarchy_node_id is null)
1248: connect by prior hierarchy_node_id = parent_hierarchy_node_id )
1249: order by lvl desc ;
1250:

Line 1247: start with hierarchy_node_id IN (select hierarchy_node_id from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id and parent_hierarchy_node_id is null)

1243: select *
1244: from (
1245: select level lvl, parent_hierarchy_node_id, hierarchy_node_id, node_type, entity_id
1246: from (select * from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id )
1247: start with hierarchy_node_id IN (select hierarchy_node_id from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id and parent_hierarchy_node_id is null)
1248: connect by prior hierarchy_node_id = parent_hierarchy_node_id )
1249: order by lvl desc ;
1250:
1251: cursor node_reverse_treewalk (p_version_id number, p_start_point number) is

Line 1255: from (select * from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id)

1251: cursor node_reverse_treewalk (p_version_id number, p_start_point number) is
1252: select *
1253: from (
1254: select level lvl, parent_hierarchy_node_id, hierarchy_node_id, node_type, entity_id
1255: from (select * from per_gen_hierarchy_nodes where hierarchy_version_id = p_version_id)
1256: start with hierarchy_node_id = p_start_point
1257: connect by prior parent_hierarchy_node_id = hierarchy_node_id )
1258: order by lvl;
1259: