VIEW: APPS.HRFV_CONTACTS

Source

View Text - Preformatted

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 ,peo.last_update_date peo_last_update_date ,cper.last_update_date cper_last_update_date ,con.last_update_date con_last_update_date 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

View Text - HTML Formatted

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
, PEO.LAST_UPDATE_DATE PEO_LAST_UPDATE_DATE
, CPER.LAST_UPDATE_DATE CPER_LAST_UPDATE_DATE
, CON.LAST_UPDATE_DATE CON_LAST_UPDATE_DATE
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