VIEW: APPS.PAY_GRADE_RULES_V

Source

View Text - Preformatted

SELECT PGR.ROWID ROW_ID , PGR.GRADE_RULE_ID , PGR.EFFECTIVE_START_DATE , PGR.EFFECTIVE_END_DATE , PGR.BUSINESS_GROUP_ID , PGR.RATE_TYPE , PGR.GRADE_OR_SPINAL_POINT_ID , PGR.RATE_ID , PSP.SPINAL_POINT PER_SPINAL_POINT , PGR.MAXIMUM , PGR.MID_VALUE , PGR.MINIMUM , DECODE(PGR.RATE_TYPE, 'SP' , PSP.SEQUENCE, 'G', PG.SEQUENCE) SEQUENCE , PGR.VALUE , PGR.REQUEST_ID , PGR.PROGRAM_APPLICATION_ID , PGR.PROGRAM_ID , PGR.PROGRAM_UPDATE_DATE , PGR.LAST_UPDATE_DATE , PGR.LAST_UPDATED_BY , PGR.LAST_UPDATE_LOGIN , PGR.CREATED_BY , PGR.CREATION_DATE , PGT.NAME PER_GRADE_NAME , PSP.SPINAL_POINT_ID ,PR.NAME RATE_NAME , decode(PGR.RATE_TYPE,'A',PGR.GRADE_OR_SPINAL_POINT_ID) ASSIGNMENT_ID , PGR.CURRENCY_CODE , CUR.NAME CURRENCY_NAME ,PGR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,PR.RATE_BASIS ,SUBSTR(hr_general.decode_lookup('RATE_BASIS',pr.rate_basis),1,80) RATE_BASIS_NAME FROM FND_SESSIONS FND, PER_GRADES_TL PGT, PER_GRADES PG, PAY_GRADE_RULES_F PGR, PER_SPINAL_POINTS PSP, PAY_RATES PR, FND_CURRENCIES_VL CUR WHERE PG.GRADE_ID (+) = PGR.GRADE_OR_SPINAL_POINT_ID AND PGT.GRADE_ID (+) = PG.GRADE_ID AND PGT.LANGUAGE (+) = userenv('LANG') AND FND.SESSION_ID = USERENV('sessionid') AND PSP.SPINAL_POINT_ID (+) = PGR.GRADE_OR_SPINAL_POINT_ID AND FND.EFFECTIVE_DATE BETWEEN PGR.EFFECTIVE_START_DATE AND PGR.EFFECTIVE_END_DATE AND CUR.CURRENCY_CODE (+) = PGR.CURRENCY_CODE AND pr.rate_id = pgr.rate_id

View Text - HTML Formatted

SELECT PGR.ROWID ROW_ID
, PGR.GRADE_RULE_ID
, PGR.EFFECTIVE_START_DATE
, PGR.EFFECTIVE_END_DATE
, PGR.BUSINESS_GROUP_ID
, PGR.RATE_TYPE
, PGR.GRADE_OR_SPINAL_POINT_ID
, PGR.RATE_ID
, PSP.SPINAL_POINT PER_SPINAL_POINT
, PGR.MAXIMUM
, PGR.MID_VALUE
, PGR.MINIMUM
, DECODE(PGR.RATE_TYPE
, 'SP'
, PSP.SEQUENCE
, 'G'
, PG.SEQUENCE) SEQUENCE
, PGR.VALUE
, PGR.REQUEST_ID
, PGR.PROGRAM_APPLICATION_ID
, PGR.PROGRAM_ID
, PGR.PROGRAM_UPDATE_DATE
, PGR.LAST_UPDATE_DATE
, PGR.LAST_UPDATED_BY
, PGR.LAST_UPDATE_LOGIN
, PGR.CREATED_BY
, PGR.CREATION_DATE
, PGT.NAME PER_GRADE_NAME
, PSP.SPINAL_POINT_ID
, PR.NAME RATE_NAME
, DECODE(PGR.RATE_TYPE
, 'A'
, PGR.GRADE_OR_SPINAL_POINT_ID) ASSIGNMENT_ID
, PGR.CURRENCY_CODE
, CUR.NAME CURRENCY_NAME
, PGR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PR.RATE_BASIS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('RATE_BASIS'
, PR.RATE_BASIS)
, 1
, 80) RATE_BASIS_NAME
FROM FND_SESSIONS FND
, PER_GRADES_TL PGT
, PER_GRADES PG
, PAY_GRADE_RULES_F PGR
, PER_SPINAL_POINTS PSP
, PAY_RATES PR
, FND_CURRENCIES_VL CUR
WHERE PG.GRADE_ID (+) = PGR.GRADE_OR_SPINAL_POINT_ID
AND PGT.GRADE_ID (+) = PG.GRADE_ID
AND PGT.LANGUAGE (+) = USERENV('LANG')
AND FND.SESSION_ID = USERENV('SESSIONID')
AND PSP.SPINAL_POINT_ID (+) = PGR.GRADE_OR_SPINAL_POINT_ID
AND FND.EFFECTIVE_DATE BETWEEN PGR.EFFECTIVE_START_DATE
AND PGR.EFFECTIVE_END_DATE
AND CUR.CURRENCY_CODE (+) = PGR.CURRENCY_CODE
AND PR.RATE_ID = PGR.RATE_ID