[Home] [Help]
View: HRFV_ADA_DISABILITIES
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_ADA_DISABILITIES
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PPA.DATE_FROM START_DATE
, PPA.DATE_TO END_DATE
, PPA.COMMENTS COMMENTS
, PAC.SEGMENT1 TYPE
, PPA.ANALYSIS_CRITERIA_ID ANALYSIS_CRITERIA_ID
, PPA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPA.ID_FLEX_NUM ID_FLEX_NUM
, PPA.PERSON_ID PERSON_ID
, PPA.PERSON_ANALYSIS_ID PERSON_ANALYSIS_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PERSON_ANALYSES PPA
, PER_ANALYSIS_CRITERIA PAC
, PER_PEOPLE_X PEO
WHERE PPA.ANALYSIS_CRITERIA_ID = PAC.ANALYSIS_CRITERIA_ID
AND PPA.ID_FLEX_NUM = PAC.ID_FLEX_NUM
AND PPA.PERSON_ID = PEO.PERSON_ID
AND PAC.ID_FLEX_NUM = 50129
AND PPA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
PERSON_NAME |
EMPLOYEE_NUMBER |
START_DATE |
END_DATE |
COMMENTS |
TYPE |
ANALYSIS_CRITERIA_ID |
BUSINESS_GROUP_ID |
ID_FLEX_NUM |
PERSON_ID |
PERSON_ANALYSIS_ID |