Product: | PER - Human Resources |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PER_CAGR_REFERENCE_GRADES_V |
SELECT PCG.CAGR_GRADE_ID
, CGD.CAGR_GRADE_DEF_ID
, PCG.CAGR_GRADE_STRUCTURE_ID
, PCG.SEQUENCE
, CGD.ID_FLEX_NUM
, CGD.SUMMARY_FLAG
, CGD.ENABLED_FLAG
, CGD.START_DATE_ACTIVE
, CGD.END_DATE_ACTIVE
, CGD.SEGMENT1
, CGD.SEGMENT2
, CGD.SEGMENT3
, CGD.SEGMENT4
, CGD.SEGMENT5
, CGD.SEGMENT6
, CGD.SEGMENT7
, CGD.SEGMENT8
, CGD.SEGMENT9
, CGD.SEGMENT10
, CGD.SEGMENT11
, CGD.SEGMENT12
, CGD.SEGMENT13
, CGD.SEGMENT14
, CGD.SEGMENT15
, CGD.SEGMENT16
, CGD.SEGMENT17
, CGD.SEGMENT18
, CGD.SEGMENT19
, CGD.SEGMENT20
, PCG.OBJECT_VERSION_NUMBER
, PCG.LAST_UPDATE_DATE
, PCG.LAST_UPDATED_BY
, PCG.LAST_UPDATE_LOGIN
, PCG.CREATED_BY
, PCG.CREATION_DATE
FROM PER_CAGR_GRADES PCG
, PER_CAGR_GRADES_DEF CGD
WHERE PCG.CAGR_GRADE_DEF_ID = CGD.CAGR_GRADE_DEF_ID