View: HRIFV_GRADE_RATES_BG

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRIFV_GRADE_RATES_BG

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ GRD.NAME GRADE_NAME
, GRD.DATE_FROM GRADE_DATE_FROM
, GRD.DATE_TO GRADE_DATE_TO
, GRL.EFFECTIVE_START_DATE GRADE_RULE_START_DATE
, GRL.EFFECTIVE_END_DATE GRADE_RULE_END_DATE
, RAT.NAME GRADE_RATE_NAME
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, RAT.RATE_UOM) UNIT_OF_MEASURE
, GRL.MAXIMUM GRADE_MAXIMUM
, GRL.MID_VALUE GRADE_MID_VALUE
, GRL.MINIMUM GRADE_MINIMUM
, GRL.VALUE GRADE_RATE_VALUE
, PPB.GRADE_ANNUALIZATION_FACTOR GRADE_ANNUALIZATION_FACTOR
, PPB.NAME PAY_BASIS_NAME /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:PAY_RATES:RAT' /* IDS */
, GRL.GRADE_RULE_ID GRADE_RULE_ID
, GRD.GRADE_ID GRADE_ID
, GRD.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
, GRD.BUSINESS_GROUP_ID GRADE_BUSINESS_GROUP_ID
, RAT.RATE_ID GRADE_RATE_ID
, GRL.GRADE_OR_SPINAL_POINT_ID GRADE_OR_SPINAL_POINT_ID
, PPB.PAY_BASIS_ID PAY_BASIS_ID
FROM PAY_GRADE_RULES_F GRL
, PER_GRADES GRD
, PAY_RATES RAT
, PER_PAY_BASES PPB
WHERE GRD.GRADE_ID = GRL.GRADE_OR_SPINAL_POINT_ID (+)
AND NVL(GRL.RATE_TYPE
, 'G') = 'G'
AND GRL.RATE_ID = RAT.RATE_ID (+)
AND PPB.RATE_ID = NVL(RAT.RATE_ID
, PPB.RATE_ID)
AND GRD.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, GRD.BUSINESS_GROUP_ID ) WITH READ ONLY

Columns