SELECT organization_id_child ,organization_id_parent ,org_structure_version_id from per_org_structure_elements WHERE pqh_budget.already_delegated_org(organization_id_child) = 'FALSE' and pqh_budget.already_delegated_org(organization_id_parent) = 'FALSE'
SELECT ORGANIZATION_ID_CHILD
, ORGANIZATION_ID_PARENT
, ORG_STRUCTURE_VERSION_ID
FROM PER_ORG_STRUCTURE_ELEMENTS
WHERE PQH_BUDGET.ALREADY_DELEGATED_ORG(ORGANIZATION_ID_CHILD) = 'FALSE'
AND PQH_BUDGET.ALREADY_DELEGATED_ORG(ORGANIZATION_ID_PARENT) = 'FALSE'
|
|
|