[Home] [Help]
View: HRFV_GRADE_STEPS
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_GRADE_STEPS
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PS.NAME PAY_SCALE_NAME
, G.NAME GRADE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DECODE(S1.STEP_ID
, GRS.CEILING_STEP_ID
, 'Y'
, 'N')) CEILING_POINT_FLAG
, PSP.SPINAL_POINT GRADE_POINT
, COUNT(*) GRADE_STEP
, GRS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, G.GRADE_ID GRADE_ID
, GRS.GRADE_SPINE_ID GRADE_SCALE_ID
, S1.STEP_ID GRADE_STEP_ID
, PS.PARENT_SPINE_ID PAY_SCALE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PARENT_SPINES PS
, PER_SPINAL_POINTS PSP
, PER_SPINAL_POINTS PSP2
, PER_SPINAL_POINT_STEPS_X S1
, PER_SPINAL_POINT_STEPS_X S2
, PER_GRADES G
, PER_GRADE_SPINES_X GRS2
, PER_GRADE_SPINES_X GRS
WHERE PS.PARENT_SPINE_ID = PSP.PARENT_SPINE_ID
AND PS.PARENT_SPINE_ID = GRS.PARENT_SPINE_ID
AND GRS.GRADE_ID = G.GRADE_ID
AND S1.SPINAL_POINT_ID = PSP.SPINAL_POINT_ID
AND GRS2.GRADE_ID = G.GRADE_ID
AND GRS2.GRADE_SPINE_ID = S2.GRADE_SPINE_ID
AND S2.SPINAL_POINT_ID = PSP2.SPINAL_POINT_ID
AND PSP.SEQUENCE >= PSP2.SEQUENCE
AND S1.GRADE_SPINE_ID = GRS.GRADE_SPINE_ID
AND GRS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND GRS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, GRS.BUSINESS_GROUP_ID) GROUP BY G.NAME
, PS.NAME
, PSP.SPINAL_POINT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DECODE(S1.STEP_ID
, GRS.CEILING_STEP_ID
, 'Y'
, 'N'))
, PS.PARENT_SPINE_ID
, GRS.BUSINESS_GROUP_ID
, G.GRADE_ID
, S1.STEP_ID
, BGRT.NAME
, GRS.GRADE_SPINE_ID WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
PAY_SCALE_NAME |
GRADE_NAME |
CEILING_POINT_FLAG |
GRADE_POINT |
GRADE_STEP |
BUSINESS_GROUP_ID |
GRADE_ID |
GRADE_SCALE_ID |
GRADE_STEP_ID |
PAY_SCALE_ID |