VIEW: APPS.HRFV_CA_PERSONAL_DETAILS

Source

View Text - Preformatted

SELECT bgr.name business_group_name , peo.full_name person_name , peo.effective_start_date effective_start_date , peo.effective_end_date effective_end_date , peo.pre_name_adjunct prefix , peo.suffix suffix , peo.first_name first_name , peo.last_name last_name , peo.known_as preferred_name , peo.middle_names middle_names , peo.title title , peo.employee_number employee_number , peo.national_identifier social_security_number , peo.per_information1 work_permit_number , peo.per_information2 work_permit_status , peo.per_information3 work_permit_end_date , DECODE(peo.per_information1, null, null, hr_bis.bis_decode_lookup('YES_NO', peo.per_information4)) woman , DECODE(peo.per_information1, null, null, hr_bis.bis_decode_lookup('YES_NO', peo.per_information5)) aboriginal , DECODE(peo.per_information1, null, null, hr_bis.bis_decode_lookup('YES_NO', peo.per_information6)) visible_minority , DECODE(peo.per_information1, null, null, hr_bis.bis_decode_lookup('YES_NO', peo.per_information7)) disabled , DECODE(peo.per_information1, null, null, hr_bis.bis_decode_lookup('YES_NO', peo.per_information8)) not_provided , DECODE(peo.per_information1, null, null, hr_bis.bis_decode_lookup('YES_NO', peo.per_information9)) unknown , '_DF:PER:PER_PEOPLE:peo' , peo.business_group_id business_group_id , peo.person_id person_id , peo.party_id party_id , peo.per_information4 woman_code , peo.per_information5 aboriginal_code , peo.per_information6 visible_minority_code , peo.per_information7 disabled_code , peo.per_information8 not_provided_code , peo.per_information9 unknown_code FROM hr_all_organization_units_tl bgr , per_people_f peo WHERE peo.business_group_id = bgr.organization_id AND peo.per_information_category = 'CA' 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 BGR.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEO.PRE_NAME_ADJUNCT PREFIX
, PEO.SUFFIX SUFFIX
, PEO.FIRST_NAME FIRST_NAME
, PEO.LAST_NAME LAST_NAME
, PEO.KNOWN_AS PREFERRED_NAME
, PEO.MIDDLE_NAMES MIDDLE_NAMES
, PEO.TITLE TITLE
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PEO.NATIONAL_IDENTIFIER SOCIAL_SECURITY_NUMBER
, PEO.PER_INFORMATION1 WORK_PERMIT_NUMBER
, PEO.PER_INFORMATION2 WORK_PERMIT_STATUS
, PEO.PER_INFORMATION3 WORK_PERMIT_END_DATE
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION4)) WOMAN
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION5)) ABORIGINAL
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION6)) VISIBLE_MINORITY
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION7)) DISABLED
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION8)) NOT_PROVIDED
, DECODE(PEO.PER_INFORMATION1
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION9)) UNKNOWN
, '_DF:PER:PER_PEOPLE:PEO'
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
, PEO.PARTY_ID PARTY_ID
, PEO.PER_INFORMATION4 WOMAN_CODE
, PEO.PER_INFORMATION5 ABORIGINAL_CODE
, PEO.PER_INFORMATION6 VISIBLE_MINORITY_CODE
, PEO.PER_INFORMATION7 DISABLED_CODE
, PEO.PER_INFORMATION8 NOT_PROVIDED_CODE
, PEO.PER_INFORMATION9 UNKNOWN_CODE
FROM HR_ALL_ORGANIZATION_UNITS_TL BGR
, PER_PEOPLE_F PEO
WHERE PEO.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND PEO.PER_INFORMATION_CATEGORY = 'CA'
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY