View: HRFV_GRADE_RATES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_GRADE_RATES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, GRD.NAME GRADE_NAME
, PPB.NAME SALARY_BASIS
, PPB.RATE_BASIS GRADE_RATE_BASIS
, RAT.NAME GRADE_RATE_NAME
, 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
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, RAT.RATE_UOM) UNIT_OF_MEASURE
, '_DF:PAY:PAY_RATES:RAT'
, ASG.PERSON_ID PERSON_ID
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.JOB_ID JOB_ID
, ASG.POSITION_ID POSITION_ID
, ASG.GRADE_ID GRADE_ID
, ASG.LOCATION_ID LOCATION_ID
, GRL.GRADE_RULE_ID GRADE_RULE_ID
, GRL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GRL.RATE_ID RATE_ID
FROM PAY_GRADE_RULES_F GRL
, PAY_RATES RAT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_GRADES GRD
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, HR_LOCATIONS_ALL_TL LOCT
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, PER_PAY_BASES PPB
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID (+)
AND ASG.GRADE_ID = GRL.GRADE_OR_SPINAL_POINT_ID
AND ASG.GRADE_ID = GRD.GRADE_ID
AND GRL.RATE_ID = RAT.RATE_ID
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND GRL.RATE_ID = NVL(PPB.RATE_ID
, GRL.RATE_ID)
AND ASG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ASG.JOB_ID = JOB.JOB_ID (+)
AND ASG.POSITION_ID = POS.POSITION_ID (+)
AND ASG.LOCATION_ID = LOCT.LOCATION_ID (+)
AND BGRT.LANGUAGE = USERENV('LANG')
AND ORGT.LANGUAGE = USERENV('LANG')
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND GRL.RATE_TYPE = 'G'
AND SYSDATE BETWEEN GRL.EFFECTIVE_START_DATE
AND GRL.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns