Product: | HRI - Human Resources Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HRIFV_PEREIT |
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ PER.FULL_NAME PERSON_NAME
, EIF.INFORMATION_TYPE INFORMATION_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EIT.ACTIVE_INACTIVE_FLAG) ACTIVE_INACTIVE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EIT.MULTIPLE_OCCURENCES_FLAG) MULTIPLE_OCCURENCES
, EIT.DESCRIPTION EXTRA_INFO_TYPE_DESCRIPTION
, EIT.LEGISLATION_CODE LEGISLATION_CODE
, PER.EFFECTIVE_START_DATE PERSON_EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE PERSON_EFFECTIVE_END_DATE
, '_DF:PER:EXTRA PERSON INFO DDF:EIF'
, '_DF:PER:PER_PEOPLE_EXTRA_INFO:EIF'
, EIT.ACTIVE_INACTIVE_FLAG ACTIVE_INACTIVE_FLAG
, EIT.MULTIPLE_OCCURENCES_FLAG MULTIPLE_OCCURENCES_FLAG
, EIF.PERSON_EXTRA_INFO_ID PERSON_EXTRA_INFO_ID
, PER.PERSON_ID PERSON_ID
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_PEOPLE_EXTRA_INFO EIF
, PER_PEOPLE_INFO_TYPES EIT
, PER_PEOPLE_F PER
WHERE EIF.INFORMATION_TYPE = EIT.INFORMATION_TYPE
AND EIF.PERSON_ID = PER.PERSON_ID
AND PER.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PER.BUSINESS_GROUP_ID) WITH READ ONLY