VIEW: APPS.HRFV_GRD_PLACEMNT_PROG_PT_VALS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,per.full_name person_name ,asg.assignment_number assignment_number ,per.employee_number employee_number ,ps.name pay_scale_name ,gdt.name grade_name ,pr.name progression_pt_rate ,pgr.value progression_pt_value ,hr_bis.bis_decode_lookup('UNITS',pr.rate_uom) progression_pt_unit ,asg.assignment_id assignment_id ,pgr.business_group_id business_group_id ,gdt.grade_id grade_id ,spp.placement_id grade_step_placement_id ,ps.parent_spine_id pay_scale_id ,per.person_id person_id ,pgr.grade_or_spinal_point_id progression_point_id FROM hr_all_organization_units_tl bgrT ,pay_rates pr ,pay_grade_rules_x pgr ,per_people_x per ,per_grades_tl gdt ,per_assignments_x asg ,per_parent_spines ps ,per_spinal_points sp ,per_spinal_point_steps_x sps ,per_spinal_point_placements_x spp WHERE pgr.rate_id = pr.rate_id AND pgr.rate_type = 'SP' AND per.person_id = asg.person_id AND sps.spinal_point_id = sp.spinal_point_id AND sp.parent_spine_id = ps.parent_spine_id AND asg.assignment_id = spp.assignment_id AND asg.grade_id = gdt.grade_id AND gdt.language = userenv('LANG') AND spp.step_id = sps.step_id AND pgr.grade_or_spinal_point_id = sps.spinal_point_id AND pgr.business_group_id = pr.business_group_id AND pgr.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pgr.business_group_id) AND pgr.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PS.NAME PAY_SCALE_NAME
, GDT.NAME GRADE_NAME
, PR.NAME PROGRESSION_PT_RATE
, PGR.VALUE PROGRESSION_PT_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, PR.RATE_UOM) PROGRESSION_PT_UNIT
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, PGR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GDT.GRADE_ID GRADE_ID
, SPP.PLACEMENT_ID GRADE_STEP_PLACEMENT_ID
, PS.PARENT_SPINE_ID PAY_SCALE_ID
, PER.PERSON_ID PERSON_ID
, PGR.GRADE_OR_SPINAL_POINT_ID PROGRESSION_POINT_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PAY_RATES PR
, PAY_GRADE_RULES_X PGR
, PER_PEOPLE_X PER
, PER_GRADES_TL GDT
, PER_ASSIGNMENTS_X ASG
, PER_PARENT_SPINES PS
, PER_SPINAL_POINTS SP
, PER_SPINAL_POINT_STEPS_X SPS
, PER_SPINAL_POINT_PLACEMENTS_X SPP
WHERE PGR.RATE_ID = PR.RATE_ID
AND PGR.RATE_TYPE = 'SP'
AND PER.PERSON_ID = ASG.PERSON_ID
AND SPS.SPINAL_POINT_ID = SP.SPINAL_POINT_ID
AND SP.PARENT_SPINE_ID = PS.PARENT_SPINE_ID
AND ASG.ASSIGNMENT_ID = SPP.ASSIGNMENT_ID
AND ASG.GRADE_ID = GDT.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
AND SPP.STEP_ID = SPS.STEP_ID
AND PGR.GRADE_OR_SPINAL_POINT_ID = SPS.SPINAL_POINT_ID
AND PGR.BUSINESS_GROUP_ID = PR.BUSINESS_GROUP_ID
AND PGR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PGR.BUSINESS_GROUP_ID)
AND PGR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG') WITH READ ONLY