View: HRFV_GRD_PLACEMNT_PROG_PT_VALS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PS.NAME PAY_SCALE_NAME
, GR.NAME GRADE_NAME
, PR.NAME PROGRESSION_PT_RATE
, PGR.VALUE PROGRESSION_PT_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, PR.RATE_UOM) PROGRESSION_PT_UNIT
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, PGR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GR.GRADE_ID GRADE_ID
, SPP.PLACEMENT_ID GRADE_STEP_PLACEMENT_ID
, PS.PARENT_SPINE_ID PAY_SCALE_ID
, PER.PERSON_ID PERSON_ID
, PGR.GRADE_OR_SPINAL_POINT_ID PROGRESSION_POINT_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PAY_RATES PR
, PAY_GRADE_RULES_X PGR
, PER_PEOPLE_X PER
, PER_GRADES GR
, PER_ASSIGNMENTS_X ASG
, PER_PARENT_SPINES PS
, PER_SPINAL_POINTS SP
, PER_SPINAL_POINT_STEPS_X SPS
, PER_SPINAL_POINT_PLACEMENTS_X SPP
WHERE PGR.RATE_ID = PR.RATE_ID
AND PGR.RATE_TYPE = 'SP'
AND PER.PERSON_ID = ASG.PERSON_ID
AND SPS.SPINAL_POINT_ID = SP.SPINAL_POINT_ID
AND SP.PARENT_SPINE_ID = PS.PARENT_SPINE_ID
AND ASG.ASSIGNMENT_ID = SPP.ASSIGNMENT_ID
AND ASG.GRADE_ID = GR.GRADE_ID
AND SPP.STEP_ID = SPS.STEP_ID
AND PGR.GRADE_OR_SPINAL_POINT_ID = SPS.SPINAL_POINT_ID
AND PGR.BUSINESS_GROUP_ID = PR.BUSINESS_GROUP_ID
AND PGR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PGR.BUSINESS_GROUP_ID)
AND PGR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns