APPS.GHG_TRANSACTIONS_API_PKG dependencies on PER_GEN_HIERARCHY

Line 1222: 'FROM PER_GEN_HIERARCHY h ' ||

1218: 'h.name, ' ||
1219: '''MANAGEMENT'', ' ||
1220: 'v.date_from, ' ||
1221: 'v.date_to ' ||
1222: 'FROM PER_GEN_HIERARCHY h ' ||
1223: ', PER_GEN_HIERARCHY_VERSIONS v ' ||
1224: 'WHERE h.hierarchy_id = v.hierarchy_id ' ||
1225: 'and h.type = ''GHG_ORGANIZATION_STRUCTURE''' ||
1226: 'AND v.status = ''A''';

Line 1223: ', PER_GEN_HIERARCHY_VERSIONS v ' ||

1219: '''MANAGEMENT'', ' ||
1220: 'v.date_from, ' ||
1221: 'v.date_to ' ||
1222: 'FROM PER_GEN_HIERARCHY h ' ||
1223: ', PER_GEN_HIERARCHY_VERSIONS v ' ||
1224: 'WHERE h.hierarchy_id = v.hierarchy_id ' ||
1225: 'and h.type = ''GHG_ORGANIZATION_STRUCTURE''' ||
1226: 'AND v.status = ''A''';
1227:

Line 1236: from PER_GEN_HIERARCHY h,

1232: write_to_log('Inserting into GHG_ORG_HIERARCHY_STRUCTURES_D');
1233: declare
1234: cursor hierarchy_versions is
1235: select v.hierarchy_version_id
1236: from PER_GEN_HIERARCHY h,
1237: PER_GEN_HIERARCHY_VERSIONS v
1238: where h.hierarchy_id = v.hierarchy_id
1239: and h.type = 'GHG_ORGANIZATION_STRUCTURE'
1240: and v.status = 'A';

Line 1237: PER_GEN_HIERARCHY_VERSIONS v

1233: declare
1234: cursor hierarchy_versions is
1235: select v.hierarchy_version_id
1236: from PER_GEN_HIERARCHY h,
1237: PER_GEN_HIERARCHY_VERSIONS v
1238: where h.hierarchy_id = v.hierarchy_id
1239: and h.type = 'GHG_ORGANIZATION_STRUCTURE'
1240: and v.status = 'A';
1241:

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: