View: PQH_DE_CS_GRADES_V

Product:	PQH - Public Sector HR
Description:
Implementation/DBA Data:	APPS.PQH_DE_CS_GRADES_V

View Text

SELECT NODE_TYPE
, HIERARCHY_NODE_ID
, PARENT_HIERARCHY_NODE_ID
, ENTITY_ID
FROM PER_GEN_HIERARCHY_NODES
WHERE HIERARCHY_VERSION_ID IN (SELECT HIERARCHY_VERSION_ID
FROM PER_GEN_HIERARCHY A
, PER_GEN_HIERARCHY_VERSIONS B
WHERE TYPE = 'REMUNERATION_REGULATION'
AND B.HIERARCHY_ID = A.HIERARCHY_ID
AND TRUNC(SYSDATE) BETWEEN NVL(DATE_FROM
, TRUNC(SYSDATE))
AND NVL(DATE_TO
, TRUNC(SYSDATE))) START WITH ENTITY_ID = 'BE'
AND PARENT_HIERARCHY_NODE_ID IS NULL CONNECT BY PARENT_HIERARCHY_NODE_ID = PRIOR HIERARCHY_NODE_ID

Columns