[Home] [Help]
View: PAY_GRADE_RULES_D
View Text
SELECT GRULE.GRADE_RULE_ID
, GRULE.EFFECTIVE_START_DATE
, GRULE.EFFECTIVE_END_DATE
, GRULE.MAXIMUM
, GRULE.MID_VALUE
, GRULE.MINIMUM
, GRULE.VALUE
, DECODE(GRULE.RATE_TYPE
, 'G'
, GRT.NAME
, 'SP'
, SPINE.SPINAL_POINT
, NULL) GRADE_OR_SPINAL_POINT
, HR1.MEANING
, GRULE.LAST_UPDATE_DATE
, FUSER.USER_NAME
, GRULE.CURRENCY_CODE
, CUR.NAME CURRENCY_NAME
FROM PAY_GRADE_RULES_F GRULE
, PER_GRADES_TL GRT
, PER_SPINAL_POINTS SPINE
, HR_LOOKUPS HR1
, FND_USER FUSER
, FND_CURRENCIES_VL CUR
WHERE GRT.GRADE_ID (+) = GRULE.GRADE_OR_SPINAL_POINT_ID
AND GRT.LANGUAGE (+) = USERENV('LANG')
AND SPINE.SPINAL_POINT_ID (+) = GRULE.GRADE_OR_SPINAL_POINT_ID
AND HR1.LOOKUP_CODE (+) = GRULE.RATE_TYPE
AND HR1.LOOKUP_TYPE (+)= 'RATE_TYPE'
AND FUSER.USER_ID (+)= GRULE.LAST_UPDATED_BY
AND CUR.CURRENCY_CODE (+) = GRULE.CURRENCY_CODE
Columns
Name |
GRADE_RULE_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
MAXIMUM |
MID_VALUE |
MINIMUM |
VALUE |
GRADE_OR_SPINAL_POINT |
RATE_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CURRENCY_CODE |
CURRENCY_NAME |