View: PAY_GRADE_RULES_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.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