View: PQH_CORPS_CAREER_PATHS_V

Product:	PQH - Public Sector HR
Description:	Corp Career path view
Implementation/DBA Data:	APPS.PQH_CORPS_CAREER_PATHS_V

View Text

SELECT CPD_FROM.NAME FROM_CORPS_NAME
, CPD_FROM.CORPS_DEFINITION_ID FROM_CORPS_ID
, PQH_CORPS_COPY.GET_GRADE_NAME(NOD.ENTITY_ID) FROM_GRADE
, PQH_CORPS_COPY.GET_GRADE_ID(NOD.ENTITY_ID) FROM_GRADE_ID
, PQH_CORPS_COPY.GET_STEP_NAME(NOD.ENTITY_ID) FROM_STEP
, NOD.ENTITY_ID STARTING_GRADE_STEP_ID
, NOD.INFORMATION5 FROM_SENIORITY
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, NOD.INFORMATION6) FROM_SENIORITY_DESC
, NOD.INFORMATION6 FROM_SENIORITY_UOM
, CPD_TO.NAME TO_CORPS_NAME
, CPD_TO.CORPS_DEFINITION_ID TO_CORPS_ID
, NOD.INFORMATION7 TO_SENIORITY
, NOD.INFORMATION8 TO_SENIORITY_UOM
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, NOD.INFORMATION8) TO_SENIORITY_DESC
, PQH_CORPS_COPY.GET_GRADE_NAME(NOD.INFORMATION3) TO_GRADE
, PQH_CORPS_COPY.GET_STEP_NAME(NOD.INFORMATION3) TO_STEP
, PQH_CORPS_COPY.GET_GRADE_ID(NOD.INFORMATION3) TO_GRADE_ID
, NOD.INFORMATION3 ENDING_GRADE_STEP_ID
, NOD.HIERARCHY_NODE_ID NODE_ID
, NOD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM PER_GEN_HIERARCHY_NODES NOD
, PQH_CORPS_DEFINITIONS CPD_FROM
, PQH_CORPS_DEFINITIONS CPD_TO
WHERE NOD.NODE_TYPE = 'CAREER_NODE'
AND NOD.INFORMATION4 = CPD_FROM.CORPS_DEFINITION_ID
AND NOD.INFORMATION9 = CPD_TO.CORPS_DEFINITION_ID

Columns