[Home] [Help]
View: HRFV_VALID_GRADES
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_VALID_GRADES
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.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 GRD
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_VALID_GRADES JVG
WHERE JVG.GRADE_ID = GRD.GRADE_ID
AND JVG.BUSINESS_GROUP_ID = GRD.BUSINESS_GROUP_ID
AND JVG.JOB_ID = JOB.JOB_ID(+)
AND JVG.POSITION_ID = POS.POSITION_ID(+)
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
Columns
Name |
BUSINESS_GROUP_NAME |
JOB_NAME |
POSITION_NAME |
GRADE_NAME |
DATE_FROM |
DATE_TO |
COMMENTS |
"_DF" |
BUSINESS_GROUP_ID |
GRADE_ID |
JOB_ID |
POSITION_ID |