VIEW: APPS.HRFV_GRADE_SCALES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,gdt.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_tl gdt ,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 gdt.grade_id = gs.grade_id AND gdt.language = userenv('LANG') 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 ,gdt.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

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, GDT.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_TL GDT
, 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 GDT.GRADE_ID = GS.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
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
, GDT.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