eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRFV_PERSONAL_MEDICAL_INFO

Source

View Text - Preformatted


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

View Text - HTML Formatted

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