SELECT distinct posv.org_structure_version_id , pos.name , posv.version_number FROM per_organization_structures pos, per_org_structure_versions posv WHERE posv.organization_structure_id = pos.organization_structure_id and exists( select '1' from pa_org_hierarchy_denorm ohd where ohd.pa_org_use_type='EXPENDITURES' and ohd.org_hierarchy_version_id = posv.org_structure_version_id )
SELECT DISTINCT POSV.ORG_STRUCTURE_VERSION_ID
, POS.NAME
, POSV.VERSION_NUMBER
FROM PER_ORGANIZATION_STRUCTURES POS
, PER_ORG_STRUCTURE_VERSIONS POSV
WHERE POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
AND EXISTS( SELECT '1'
FROM PA_ORG_HIERARCHY_DENORM OHD
WHERE OHD.PA_ORG_USE_TYPE='EXPENDITURES'
AND OHD.ORG_HIERARCHY_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID )
|
|
|