View: PA_ORGANIZATIONS_BURDEN_V

Product:	PA - Projects
Description:	10SC Only - View to display organizations in the project burdening hierarchy for which you can enter - Retrofitted
Implementation/DBA Data:	APPS.PA_ORGANIZATIONS_BURDEN_V

View Text

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'))

Columns