[Home] [Help]
View: HRFV_GRADES
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_GRADES
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, '_KF:PER:GRD:GDEF'
, GRD.DATE_FROM DATE_FROM
, GRD.DATE_TO DATE_TO
, GRD.COMMENTS COMMENTS
, GRD.SEQUENCE SEQUENCE
, '_DF:PER:PER_GRADES:GRD'
, GRD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GRD.GRADE_ID GRADE_ID
, GDEF.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_GRADE_DEFINITIONS GDEF
, PER_GRADES GRD
WHERE GDEF.GRADE_DEFINITION_ID = GRD.GRADE_DEFINITION_ID
AND GDEF.ENABLED_FLAG = 'Y'
AND GRD.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND GRD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, GRD.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
"_KF:GRADE_NAME" |
DATE_FROM |
DATE_TO |
COMMENTS |
SEQUENCE |
"_DF" |
BUSINESS_GROUP_ID |
GRADE_ID |
GRADE_DEFINITION_ID |