VIEW: APPS.PA_ORGANIZATIONS_BURDEN_V

Source

View Text - Preformatted

SELECT o.organization_id , o.name , o.business_group_id , o.date_from , o.date_to FROM hr_organization_units o WHERE o.organization_id IN ( SELECT se.organization_id_child FROM per_org_structure_elements se WHERE se.org_structure_version_id = (SELECT to_number(info.org_information2) FROM hr_organization_information info WHERE info.org_information_context||'' = 'Project Burdening Hierarchy' and info.organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') ) UNION ALL SELECT pa_utils.get_org_hierarchy_top(to_number(info.org_information2)) FROM hr_organization_information info WHERE info.org_information_context||'' = 'Project Burdening Hierarchy' AND info.organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID
, O.NAME
, O.BUSINESS_GROUP_ID
, O.DATE_FROM
, O.DATE_TO
FROM HR_ORGANIZATION_UNITS O
WHERE O.ORGANIZATION_ID IN ( SELECT SE.ORGANIZATION_ID_CHILD
FROM PER_ORG_STRUCTURE_ELEMENTS SE
WHERE SE.ORG_STRUCTURE_VERSION_ID = (SELECT TO_NUMBER(INFO.ORG_INFORMATION2)
FROM HR_ORGANIZATION_INFORMATION INFO
WHERE INFO.ORG_INFORMATION_CONTEXT||'' = 'PROJECT BURDENING HIERARCHY'
AND INFO.ORGANIZATION_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) UNION ALL SELECT PA_UTILS.GET_ORG_HIERARCHY_TOP(TO_NUMBER(INFO.ORG_INFORMATION2))
FROM HR_ORGANIZATION_INFORMATION INFO
WHERE INFO.ORG_INFORMATION_CONTEXT||'' = 'PROJECT BURDENING HIERARCHY'
AND INFO.ORGANIZATION_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))