VIEW: APPS.HRFV_GRADE_STEPS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,ps.name pay_scale_name ,gdt.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 ,gdt.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_tl gdt ,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 = gdt.grade_id AND gdt.language = userenv('LANG') AND s1.spinal_point_id = psp.spinal_point_id AND grs2.grade_id = gdt.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 gdt.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 ,gdt.grade_id ,s1.step_id ,bgrT.name ,grs.grade_spine_id WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PS.NAME PAY_SCALE_NAME
, GDT.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
, GDT.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_TL GDT
, 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 = GDT.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
AND S1.SPINAL_POINT_ID = PSP.SPINAL_POINT_ID
AND GRS2.GRADE_ID = GDT.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 GDT.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
, GDT.GRADE_ID
, S1.STEP_ID
, BGRT.NAME
, GRS.GRADE_SPINE_ID WITH READ ONLY