View: HRFV_GRADE_STEP_PLACEMENTS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, GS.GRADE_NAME GRADE_NAME
, GS.PAY_SCALE_NAME PAY_SCALE_NAME
, GS.CEILING_STEP CEILING_STEP
, GS.CEILING_POINT CEILING_POINT
, GSP.GRADE_STEP GRADE_STEP
, GSP.GRADE_POINT GRADE_POINT
, SPP.REASON PLACEMENT_REASON
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ASS.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GS.GRADE_ID GRADE_ID
, GSP.GRADE_STEP_ID GRADE_STEP_ID
, SPP.PLACEMENT_ID GRADE_STEP_PLACEMENTS_ID
, GS.PAY_SCALE_ID PAY_SCALE_ID
, PER.PERSON_ID PERSON_ID
FROM PER_PEOPLE_X PER
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HRFV_GRADE_STEPS GSP
, HRFV_GRADE_SCALES GS
, PER_ASSIGNMENTS_X ASS
, PER_SPINAL_POINT_PLACEMENTS_X SPP
WHERE ASS.ASSIGNMENT_ID = SPP.ASSIGNMENT_ID
AND SPP.STEP_ID = GSP.GRADE_STEP_ID
AND GSP.GRADE_SCALE_ID = GS.GRADE_SCALE_ID
AND ASS.PERSON_ID = PER.PERSON_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns