Product: | GHR - US Federal Human Resources |
---|---|
Description: | Position Description Classifications view details |
Implementation/DBA Data: | APPS.GHR_PD_CLASSIFICATIONS_V2 |
SELECT PDC. ROWID ROW_ID
, PDC.PD_CLASSIFICATION_ID
, PDC.POSITION_DESCRIPTION_ID
, PDC.CLASS_GRADE_BY
, PDC.OFFICIAL_TITLE
, PDC.PAY_PLAN
, PDC.OCCUPATIONAL_CODE
, PDC.GRADE_LEVEL
, PDC.OBJECT_VERSION_NUMBER
, PDC.LAST_UPDATE_DATE
, PDC.LAST_UPDATED_BY
, PDC.LAST_UPDATE_LOGIN
, PDC.CREATED_BY
, PDC.CREATION_DATE
, CL1.MEANING D_CLASS_GRADE_BY
, PPL.DESCRIPTION D_PAY_PLAN
, CL2.MEANING D_GRADE_OR_LEVEL
FROM GHR_PD_CLASSIFICATIONS PDC
, GHR_PAY_PLANS PPL
, FND_COMMON_LOOKUPS CL1
, FND_COMMON_LOOKUPS CL2
WHERE CL1.LOOKUP_TYPE = 'GHR_US_CLASS_GRADE_BY'
AND CL1.LOOKUP_CODE = PDC.CLASS_GRADE_BY
AND CL1.APPLICATION_ID = 800
AND CL2.LOOKUP_TYPE = 'GHR_US_GRADE_OR_LEVEL'
AND CL2.LOOKUP_CODE= PDC.GRADE_LEVEL
AND CL2.APPLICATION_ID = 800
AND PPL.PAY_PLAN = PDC.PAY_PLAN