View: PAY_GRADE_RULES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_GRADE_RULES_V

View Text

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

Columns