Product: | PER - Human Resources |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.HRFV_CONTACTS |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, CPER.FULL_NAME CONTACT_PERSON_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.PRIMARY_CONTACT_FLAG) PRIMARY_CONTACT
, HR_BIS.BIS_DECODE_LOOKUP('CONTACT'
, CON.CONTACT_TYPE) CONTACT_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.DEPENDENT_FLAG) DEPENDENT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.THIRD_PARTY_PAY_FLAG) THIRD_PARTY_PAY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.BENEFICIARY_FLAG) BENEFICIARY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.BONDHOLDER_FLAG) BOND_HOLDER
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, '_DF:PER:PER_CONTACTS:CON'
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CON.CONTACT_PERSON_ID CONTACT_PERSON_ID
, PEO.PERSON_ID PERSON_ID
FROM PER_CONTACT_RELATIONSHIPS CON
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ALL_PEOPLE_F CPER
WHERE PEO.PERSON_ID = CON.PERSON_ID
AND CPER.PERSON_ID = CON.CONTACT_PERSON_ID
AND 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)
AND TRUNC(SYSDATE) BETWEEN CPER.EFFECTIVE_START_DATE
AND CPER.EFFECTIVE_END_DATE WITH READ ONLY