VIEW: APPS.PAY_GRADE_RULES_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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