VIEW: APPS.PQH_DE_RR_GRADE2_V

Source

View Text - Preformatted

SELECT distinct pgt.NAME Pay_Grade ,pghn1.ENTITY_ID Pay_Grade_Id ,pghn8.ENTITY_ID Emp_Id ,pghv.business_group_id Business_Group_Id ,pghv.DATE_FROM Date_From ,pghv.DATE_TO Date_To from per_gen_hierarchy_nodes pghn, per_gen_hierarchy_versions pghv, per_gen_hierarchy pgh ,PER_GEN_HIERARCHY_NODES pghn1 ,PER_GEN_HIERARCHY_NODES pghn2 ,PER_GEN_HIERARCHY_NODES pghn3 ,PER_GEN_HIERARCHY_NODES pghn4 ,PER_GEN_HIERARCHY_NODES pghn5 ,PER_GEN_HIERARCHY_NODES pghn6 ,PER_GEN_HIERARCHY_NODES pghn7 ,PER_GEN_HIERARCHY_NODES pghn8 ,PER_GRADES_TL pgt ,pqh_de_case_groups pdcg WHERE pgh.TYPE='REMUNERATION_REGULATION' and pghv.HIERARCHY_ID=pgh.HIERARCHY_ID and pghn.HIERARCHY_VERSION_ID=pghv.HIERARCHY_VERSION_ID and pghn.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID and pghn.NODE_TYPE ='CASE_GROUP' and pghn1.NODE_TYPE ='PAY_GRADE' and pghn1.PARENT_HIERARCHY_NODE_ID = pghn2.HIERARCHY_NODE_ID and pghn2.NODE_TYPE ='TYPE_OF_SERVICE' and pghn2.PARENT_HIERARCHY_NODE_ID = pghn3.HIERARCHY_NODE_ID and pghn3.NODE_TYPE ='TATIGKEIT' and pghn3.PARENT_HIERARCHY_NODE_ID = pghn4.HIERARCHY_NODE_ID and pghn4.NODE_TYPE ='JOB_GROUP' and pghn4.PARENT_HIERARCHY_NODE_ID = pghn5.HIERARCHY_NODE_ID and pghn5.NODE_TYPE ='REMUN_REGLT' and pghn5.PARENT_HIERARCHY_NODE_ID = pghn6.HIERARCHY_NODE_ID and pghn6.NODE_TYPE ='TARIFF_GROUP' and pghn6.PARENT_HIERARCHY_NODE_ID = pghn7.HIERARCHY_NODE_ID and pghn7.NODE_TYPE ='TARIFF_CONTRACT' and pghn7.PARENT_HIERARCHY_NODE_ID = pghn8.HIERARCHY_NODE_ID and pghn8.NODE_TYPE ='EMP_TYPE' and to_char(pgt.GRADE_ID) = pghn1.ENTITY_ID and pgt.language = userenv('LANG') and to_char(pdcg.CASE_GROUP_ID) = pghn.ENTITY_ID

View Text - HTML Formatted

SELECT DISTINCT PGT.NAME PAY_GRADE
, PGHN1.ENTITY_ID PAY_GRADE_ID
, PGHN8.ENTITY_ID EMP_ID
, PGHV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PGHV.DATE_FROM DATE_FROM
, PGHV.DATE_TO DATE_TO
FROM PER_GEN_HIERARCHY_NODES PGHN
, PER_GEN_HIERARCHY_VERSIONS PGHV
, PER_GEN_HIERARCHY PGH
, PER_GEN_HIERARCHY_NODES PGHN1
, PER_GEN_HIERARCHY_NODES PGHN2
, PER_GEN_HIERARCHY_NODES PGHN3
, PER_GEN_HIERARCHY_NODES PGHN4
, PER_GEN_HIERARCHY_NODES PGHN5
, PER_GEN_HIERARCHY_NODES PGHN6
, PER_GEN_HIERARCHY_NODES PGHN7
, PER_GEN_HIERARCHY_NODES PGHN8
, PER_GRADES_TL PGT
, PQH_DE_CASE_GROUPS PDCG
WHERE PGH.TYPE='REMUNERATION_REGULATION'
AND PGHV.HIERARCHY_ID=PGH.HIERARCHY_ID
AND PGHN.HIERARCHY_VERSION_ID=PGHV.HIERARCHY_VERSION_ID
AND PGHN.PARENT_HIERARCHY_NODE_ID = PGHN1.HIERARCHY_NODE_ID
AND PGHN.NODE_TYPE ='CASE_GROUP'
AND PGHN1.NODE_TYPE ='PAY_GRADE'
AND PGHN1.PARENT_HIERARCHY_NODE_ID = PGHN2.HIERARCHY_NODE_ID
AND PGHN2.NODE_TYPE ='TYPE_OF_SERVICE'
AND PGHN2.PARENT_HIERARCHY_NODE_ID = PGHN3.HIERARCHY_NODE_ID
AND PGHN3.NODE_TYPE ='TATIGKEIT'
AND PGHN3.PARENT_HIERARCHY_NODE_ID = PGHN4.HIERARCHY_NODE_ID
AND PGHN4.NODE_TYPE ='JOB_GROUP'
AND PGHN4.PARENT_HIERARCHY_NODE_ID = PGHN5.HIERARCHY_NODE_ID
AND PGHN5.NODE_TYPE ='REMUN_REGLT'
AND PGHN5.PARENT_HIERARCHY_NODE_ID = PGHN6.HIERARCHY_NODE_ID
AND PGHN6.NODE_TYPE ='TARIFF_GROUP'
AND PGHN6.PARENT_HIERARCHY_NODE_ID = PGHN7.HIERARCHY_NODE_ID
AND PGHN7.NODE_TYPE ='TARIFF_CONTRACT'
AND PGHN7.PARENT_HIERARCHY_NODE_ID = PGHN8.HIERARCHY_NODE_ID
AND PGHN8.NODE_TYPE ='EMP_TYPE'
AND TO_CHAR(PGT.GRADE_ID) = PGHN1.ENTITY_ID
AND PGT.LANGUAGE = USERENV('LANG')
AND TO_CHAR(PDCG.CASE_GROUP_ID) = PGHN.ENTITY_ID