View: PQH_POSN_CTL_HIERARCHY_V

Product:	PQH - Public Sector HR
Description:	Position Control Hierarchy View
Implementation/DBA Data:	APPS.PQH_POSN_CTL_HIERARCHY_V

View Text

SELECT 0 ROW_NUM
, 0 HIERARCHY_LEVEL
, HR_GENERAL.DECODE_ORGANIZATION(BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HR_GENERAL.DECODE_ORGANIZATION(ORGANIZATION_ID) ORGANIZATION_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, PQH_PSF_BUS.POSITION_CONTROL_ENABLED(ORGANIZATION_ID) PC_ENABLED_FLAG
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = PQH_PSF_BUS.GET_PC_TOPNODE
AND NVL(PQH_PSF_BUS.POSITION_CONTROL_ENABLED(ORGANIZATION_ID)
, 'N') = 'Y' UNION SELECT ROWNUM ROW_NUM
, LEVEL HIERARCHY_LEVEL
, HR_GENERAL.DECODE_ORGANIZATION(A.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, A.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HR_GENERAL.DECODE_ORGANIZATION(A.ORGANIZATION_ID_CHILD ) ORGANIZATION_NAME
, A.ORGANIZATION_ID_CHILD ORGANIZATION_ID
, PQH_PSF_BUS.POSITION_CONTROL_ENABLED(A.ORGANIZATION_ID_CHILD) PC_ENABLED_FLAG
FROM PER_ORG_STRUCTURE_ELEMENTS A
WHERE A.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
AND NVL(PQH_PSF_BUS.POSITION_CONTROL_ENABLED(A.ORGANIZATION_ID_CHILD)
, 'N') = 'Y' START WITH ORGANIZATION_ID_PARENT = PQH_PSF_BUS.GET_PC_TOPNODE
AND ORG_STRUCTURE_VERSION_ID = PQH_PSF_BUS.GET_PC_STR_VERSION CONNECT BY A.ORGANIZATION_ID_PARENT = PRIOR A.ORGANIZATION_ID_CHILD
AND A.ORG_STRUCTURE_VERSION_ID = PRIOR A.ORG_STRUCTURE_VERSION_ID

Columns