APPS.GHG_TRANSACTIONS_API_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

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