View: PQH_WORKSHEET_ORGANIZATIONS_V

Product:	PQH - Public Sector HR
Description:	Worksheet Organization View
Implementation/DBA Data:	APPS.PQH_WORKSHEET_ORGANIZATIONS_V

View Text

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'

Columns