VIEW: APPS.HRFV_VALID_GRADES

Source

View Text - Preformatted

SELECT bgrt.name business_group_name ,jbt.name job_name ,pft.name position_name ,gdt.name grade_name ,jvg.date_from date_from ,jvg.date_to date_to ,jvg.comments comments ,'_DF:PER:PER_VALID_GRADES:jvg' ,jvg.business_group_id business_group_id ,jvg.grade_id grade_id ,jvg.job_id job_id ,jvg.position_id position_id FROM per_grades_tl gdt ,per_grades grd ,hr_all_organization_units_tl bgrT ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_valid_grades jvg WHERE jvg.grade_id = grd.grade_id AND jvg.business_group_id = grd.business_group_id AND jvg.grade_id = gdt.grade_id AND gdt.language = userenv('LANG') AND jvg.job_id = jbt.job_id(+) AND jbt.language(+) = userenv('LANG') AND jvg.position_id = pft.position_id(+) AND pft.language(+) = userenv('LANG') AND bgrT.language = userenv('LANG') AND jvg.business_group_id = bgrT.organization_id AND jvg.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, jvg.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JBT.NAME JOB_NAME
, PFT.NAME POSITION_NAME
, GDT.NAME GRADE_NAME
, JVG.DATE_FROM DATE_FROM
, JVG.DATE_TO DATE_TO
, JVG.COMMENTS COMMENTS
, '_DF:PER:PER_VALID_GRADES:JVG'
, JVG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JVG.GRADE_ID GRADE_ID
, JVG.JOB_ID JOB_ID
, JVG.POSITION_ID POSITION_ID
FROM PER_GRADES_TL GDT
, PER_GRADES GRD
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_VALID_GRADES JVG
WHERE JVG.GRADE_ID = GRD.GRADE_ID
AND JVG.BUSINESS_GROUP_ID = GRD.BUSINESS_GROUP_ID
AND JVG.GRADE_ID = GDT.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
AND JVG.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND JVG.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND BGRT.LANGUAGE = USERENV('LANG')
AND JVG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND JVG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JVG.BUSINESS_GROUP_ID) WITH READ ONLY