[Home] [Help]
77: (
78: SELECT
79: ORGANIZATION_ID_CHILD
80: FROM
81: PER_ORG_STRUCTURE_ELEMENTS
82: WHERE
83: ORG_STRUCTURE_VERSION_ID = P_PJP_ORG_VERSION_ID
84: CONNECT BY PRIOR ORGANIZATION_ID_CHILD = ORGANIZATION_ID_PARENT
85: AND PRIOR ORG_STRUCTURE_VERSION_ID = P_PJP_ORG_VERSION_ID