[Home] [Help]
View: HRFV_PERSONAL_MEDICAL_INFO
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_PERSONAL_MEDICAL_INFO
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HR_BIS.BIS_DECODE_LOOKUP('BLOOD_TYPE'
, PEO.BLOOD_TYPE) BLOOD_TYPE
, PEO.LAST_MEDICAL_TEST_BY LAST_MEDICAL_PERFORMED_BY
, PEO.LAST_MEDICAL_TEST_DATE LAST_MEDICAL_DATE
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
WHERE PEO.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
PERSON_NAME |
BLOOD_TYPE |
LAST_MEDICAL_PERFORMED_BY |
LAST_MEDICAL_DATE |
BUSINESS_GROUP_ID |
PERSON_ID |