VIEW: APPS.HRFV_US_PERSONAL_DETAILS

Source

View Text - Preformatted

SELECT bgr.name business_group_name ,peo.full_name person_name ,peo.employee_number employee_number ,peo.national_identifier social_security_number ,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 ,hr_bis.bis_decode_lookup('US_ETHNIC_GROUP',peo.per_information1) ethnic_origin ,hr_bis.bis_decode_lookup('PER_US_I9_STATE',peo.per_information2) i9 ,fnd_date.canonical_to_date(peo.per_information3) i9_expiry_date ,hr_bis.bis_decode_lookup('US_VISA_TYPE',peo.per_information4) visa_type ,hr_bis.bis_decode_lookup('US_VETERAN_STATUS',peo.per_information5) vietnam_vets_status ,hr_bis.bis_decode_lookup('YES_NO',peo.per_information6) student ,hr_bis.bis_decode_lookup('US_NEW_HIRE_STATUS', peo.per_information7) new_hire_status ,peo.per_information8 exclusion_reason ,hr_bis.bis_decode_lookup('YES_NO',peo.per_information9) child_support_obligation ,'_DF:PER:PER_PEOPLE:peo' ,peo.business_group_id business_group_id ,peo.person_id person_id FROM per_business_groups bgr ,per_people_x peo WHERE peo.business_group_id = bgr.organization_id AND bgr.legislation_code = 'US' 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.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PEO.NATIONAL_IDENTIFIER SOCIAL_SECURITY_NUMBER
, 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
, HR_BIS.BIS_DECODE_LOOKUP('US_ETHNIC_GROUP'
, PEO.PER_INFORMATION1) ETHNIC_ORIGIN
, HR_BIS.BIS_DECODE_LOOKUP('PER_US_I9_STATE'
, PEO.PER_INFORMATION2) I9
, FND_DATE.CANONICAL_TO_DATE(PEO.PER_INFORMATION3) I9_EXPIRY_DATE
, HR_BIS.BIS_DECODE_LOOKUP('US_VISA_TYPE'
, PEO.PER_INFORMATION4) VISA_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('US_VETERAN_STATUS'
, PEO.PER_INFORMATION5) VIETNAM_VETS_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION6) STUDENT
, HR_BIS.BIS_DECODE_LOOKUP('US_NEW_HIRE_STATUS'
, PEO.PER_INFORMATION7) NEW_HIRE_STATUS
, PEO.PER_INFORMATION8 EXCLUSION_REASON
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PER_INFORMATION9) CHILD_SUPPORT_OBLIGATION
, '_DF:PER:PER_PEOPLE:PEO'
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM PER_BUSINESS_GROUPS BGR
, PER_PEOPLE_X PEO
WHERE PEO.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.LEGISLATION_CODE = 'US'
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY