[Home] [Help]
View: HRFV_GRADE_SCALES
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_GRADE_SCALES
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, G.NAME GRADE_NAME
, PS.NAME PAY_SCALE_NAME
, SP1.SPINAL_POINT CEILING_POINT
, COUNT(*) CEILING_STEP
, '_DF:PER:PER_PARENT_SPINES:PS'
, PS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GS.GRADE_ID GRADE_ID
, GS.GRADE_SPINE_ID GRADE_SCALE_ID
, PS.PARENT_SPINE_ID PAY_SCALE_ID
, SPS.STEP_ID CEILING_POINT_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_GRADES G
, PER_GRADE_SPINES_X GS
, PER_SPINAL_POINT_STEPS_X SPS
, PER_PARENT_SPINES PS
, PER_SPINAL_POINTS SP1
, PER_SPINAL_POINT_STEPS_X SPS1
, PER_SPINAL_POINTS P2
, PER_SPINAL_POINT_STEPS_X S2
, PER_GRADE_SPINES_X GS2
WHERE G.GRADE_ID = GS.GRADE_ID
AND PS.PARENT_SPINE_ID = GS.PARENT_SPINE_ID
AND SPS1.SPINAL_POINT_ID = SP1.SPINAL_POINT_ID
AND GS.CEILING_STEP_ID = SPS1.STEP_ID
AND SPS.SPINAL_POINT_ID = SP1.SPINAL_POINT_ID
AND SPS.GRADE_SPINE_ID = GS.GRADE_SPINE_ID
AND S2.SPINAL_POINT_ID = P2.SPINAL_POINT_ID
AND SP1.SEQUENCE >= P2.SEQUENCE
AND GS2.GRADE_SPINE_ID = S2.GRADE_SPINE_ID
AND GS2.GRADE_ID = GS.GRADE_ID
AND GS2.PARENT_SPINE_ID = GS.PARENT_SPINE_ID
AND PS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PS.BUSINESS_GROUP_ID)
AND PS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG') GROUP BY BGRT.NAME
, G.NAME
, PS.NAME
, SP1.SPINAL_POINT
, PS.BUSINESS_GROUP_ID
, GS.GRADE_ID
, GS.GRADE_SPINE_ID
, PS.PARENT_SPINE_ID
, SPS.STEP_ID WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
GRADE_NAME |
PAY_SCALE_NAME |
CEILING_POINT |
CEILING_STEP |
"_DF" |
BUSINESS_GROUP_ID |
GRADE_ID |
GRADE_SCALE_ID |
PAY_SCALE_ID |
CEILING_POINT_ID |