VIEW: APPS.PQH_DE_CS_GRADES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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