VIEW: APPS.HRFV_GRADE_STEP_PLACEMENTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,per.full_name person_name ,gs.grade_name grade_name ,gs.pay_scale_name pay_scale_name ,gs.ceiling_step ceiling_step ,gs.ceiling_point ceiling_point ,gsp.grade_step grade_step ,gsp.grade_point grade_point ,spp.reason placement_reason ,per.employee_number employee_number ,ass.assignment_number assignment_number ,ass.assignment_id assignment_id ,ass.business_group_id business_group_id ,gs.grade_id grade_id ,gsp.grade_step_id grade_step_id ,spp.placement_id grade_step_placements_id ,gs.pay_scale_id pay_scale_id ,per.person_id person_id FROM per_people_x per ,hr_all_organization_units_tl bgrT ,hrfv_grade_steps gsp ,hrfv_grade_scales gs ,per_assignments_x ass ,per_spinal_point_placements_x spp WHERE ass.assignment_id = spp.assignment_id AND spp.step_id = gsp.grade_step_id AND gsp.grade_scale_id = gs.grade_scale_id AND ass.person_id = per.person_id AND ass.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND ass.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,ass.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, GS.GRADE_NAME GRADE_NAME
, GS.PAY_SCALE_NAME PAY_SCALE_NAME
, GS.CEILING_STEP CEILING_STEP
, GS.CEILING_POINT CEILING_POINT
, GSP.GRADE_STEP GRADE_STEP
, GSP.GRADE_POINT GRADE_POINT
, SPP.REASON PLACEMENT_REASON
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ASS.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GS.GRADE_ID GRADE_ID
, GSP.GRADE_STEP_ID GRADE_STEP_ID
, SPP.PLACEMENT_ID GRADE_STEP_PLACEMENTS_ID
, GS.PAY_SCALE_ID PAY_SCALE_ID
, PER.PERSON_ID PERSON_ID
FROM PER_PEOPLE_X PER
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HRFV_GRADE_STEPS GSP
, HRFV_GRADE_SCALES GS
, PER_ASSIGNMENTS_X ASS
, PER_SPINAL_POINT_PLACEMENTS_X SPP
WHERE ASS.ASSIGNMENT_ID = SPP.ASSIGNMENT_ID
AND SPP.STEP_ID = GSP.GRADE_STEP_ID
AND GSP.GRADE_SCALE_ID = GS.GRADE_SCALE_ID
AND ASS.PERSON_ID = PER.PERSON_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) WITH READ ONLY