View: HRFV_GRD_STEP_PLACEMNT_HISTORY

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PS.NAME PAY_SCALE_NAME
, G.NAME GRADE_NAME
, COUNT(*) GRADE_STEP
, PSP.SPINAL_POINT GRADE_POINT
, HR_BIS.BIS_DECODE_LOOKUP('PLACEMENT_REASON'
, PSPP.REASON) PLACEMENT_REASON
, PSPP.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(PSPP.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, PA.ASSIGNMENT_ID ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PA.GRADE_ID GRADE_ID
, PSP.SPINAL_POINT_ID PAY_SCALE_ID
, PER.PERSON_ID PERSON_ID
, PSPS.STEP_ID STEP_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_GRADES G
, PER_PARENT_SPINES PS
, PER_SPINAL_POINTS PSP
, PER_PEOPLE_X PER
, PER_ASSIGNMENTS_F PA
, PER_SPINAL_POINT_STEPS_F PSPS
, PER_SPINAL_POINT_STEPS_F PSPS2
, PER_SPINAL_POINT_PLACEMENTS_F PSPP
WHERE PSPP.ASSIGNMENT_ID = PA.ASSIGNMENT_ID
AND PS.PARENT_SPINE_ID = PSP.PARENT_SPINE_ID
AND PA.PERSON_ID = PER.PERSON_ID
AND G.GRADE_ID = PA.GRADE_ID
AND PSPP.STEP_ID = PSPS.STEP_ID
AND PSPS.SPINAL_POINT_ID = PSP.SPINAL_POINT_ID
AND PSPS.GRADE_SPINE_ID = PSPS2.GRADE_SPINE_ID
AND PSPS.SEQUENCE >= PSPS2.SEQUENCE
AND PA.ASSIGNMENT_TYPE = 'E'
AND PSPP.EFFECTIVE_START_DATE BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE
AND PA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PA.BUSINESS_GROUP_ID)
AND PA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG') GROUP BY BGRT.NAME
, PER.FULL_NAME
, PER.EMPLOYEE_NUMBER
, PA.ASSIGNMENT_NUMBER
, PS.NAME
, G.NAME
, PSP.SPINAL_POINT
, PSPP.REASON
, PSPP.EFFECTIVE_START_DATE
, PSPP.EFFECTIVE_END_DATE
, PA.ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID
, PA.GRADE_ID
, PSP.SPINAL_POINT_ID
, PER.PERSON_ID
, PSPS.STEP_ID WITH READ ONLY

Columns