VIEW: APPS.IGW_APR_ORGANIZATIONS_V

Source

View Text - Preformatted

SELECT hr.organization_id, hr.name, hr.business_group_id from hr_organization_units hr WHERE hr.organization_id in ( select se.organization_id_child from per_org_structure_elements se where se.org_structure_version_id = ( select apr_org_structure_version_id from igw_implementations ) connect by prior se.organization_id_child = se.organization_id_parent and prior se.org_structure_version_id = se.org_structure_version_id start with se.organization_id_parent = ( select apr_org_structure_start_id from igw_implementations ) union select apr_org_structure_start_id from igw_implementations ) and trunc(sysdate) between date_from and nvl(date_to, trunc(sysdate))

View Text - HTML Formatted

SELECT HR.ORGANIZATION_ID
, HR.NAME
, HR.BUSINESS_GROUP_ID
FROM HR_ORGANIZATION_UNITS HR
WHERE HR.ORGANIZATION_ID IN ( SELECT SE.ORGANIZATION_ID_CHILD
FROM PER_ORG_STRUCTURE_ELEMENTS SE
WHERE SE.ORG_STRUCTURE_VERSION_ID = ( SELECT APR_ORG_STRUCTURE_VERSION_ID
FROM IGW_IMPLEMENTATIONS ) CONNECT BY PRIOR SE.ORGANIZATION_ID_CHILD = SE.ORGANIZATION_ID_PARENT
AND PRIOR SE.ORG_STRUCTURE_VERSION_ID = SE.ORG_STRUCTURE_VERSION_ID START WITH SE.ORGANIZATION_ID_PARENT = ( SELECT APR_ORG_STRUCTURE_START_ID
FROM IGW_IMPLEMENTATIONS ) UNION SELECT APR_ORG_STRUCTURE_START_ID
FROM IGW_IMPLEMENTATIONS )
AND TRUNC(SYSDATE) BETWEEN DATE_FROM
AND NVL(DATE_TO
, TRUNC(SYSDATE))