VIEW: APPS.HRBV_CONTACT_RELATIONSHIP

Source

View Text - Preformatted

SELECT con.comments comments ,con.date_start date_start ,con.date_end date_end ,con.sequence_number sequence_number ,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 ,hr_bis.bis_decode_lookup('YES_NO',con.personal_flag) personal_flag ,hr_bis.bis_decode_lookup('YES_NO',con.rltd_per_rsds_w_dsgntr_flag) rltd_per_rsds_w_dsgntr_flag ,con.primary_contact_flag primary_contact_flag_code ,con.contact_type contact_type_code ,con.dependent_flag dependent_flag_code ,con.third_party_pay_flag third_party_pay_flag_code ,con.beneficiary_flag beneficiary_flag_code ,con.bondholder_flag bondholder_flag_code ,con.personal_flag personal_flag_code ,con.rltd_per_rsds_w_dsgntr_flag rd_p_rsds_w_dsr_flag_code ,con.cont_information_category cont_information_category ,con.cont_information1 cont_information1 ,con.cont_information2 cont_information2 ,con.cont_information3 cont_information3 ,con.cont_information4 cont_information4 ,con.cont_information5 cont_information5 ,con.cont_information6 cont_information6 ,con.cont_information7 cont_information7 ,con.cont_information8 cont_information8 ,con.cont_information9 cont_information9 ,con.cont_information10 cont_information10 ,con.cont_information11 cont_information11 ,con.cont_information12 cont_information12 ,con.cont_information13 cont_information13 ,con.cont_information14 cont_information14 ,con.cont_information15 cont_information15 ,con.cont_information16 cont_information16 ,con.cont_information17 cont_information17 ,con.cont_information18 cont_information18 ,con.cont_information19 cont_information19 ,con.cont_information20 cont_information20 ,'_DF:PER:PER_CONTACTS:con' ,hr_api.return_legislation_code(con.business_group_id) legislation_code ,con.business_group_id business_group_id ,con.contact_person_id contact_person_id ,con.contact_relationship_id contact_relationship_id ,con.person_id person_id ,con.start_life_reason_id start_life_reason_id ,con.end_life_reason_id end_life_reason_id ,con.last_update_date last_update_date ,con.last_updated_by last_updated_by ,con.last_update_login last_update_login ,con.created_by created_by ,con.creation_date creation_date ,CASE WHEN (con.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, con.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_contact_relationships con WITH READ ONLY

View Text - HTML Formatted

SELECT CON.COMMENTS COMMENTS
, CON.DATE_START DATE_START
, CON.DATE_END DATE_END
, CON.SEQUENCE_NUMBER SEQUENCE_NUMBER
, 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
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.PERSONAL_FLAG) PERSONAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CON.RLTD_PER_RSDS_W_DSGNTR_FLAG) RLTD_PER_RSDS_W_DSGNTR_FLAG
, CON.PRIMARY_CONTACT_FLAG PRIMARY_CONTACT_FLAG_CODE
, CON.CONTACT_TYPE CONTACT_TYPE_CODE
, CON.DEPENDENT_FLAG DEPENDENT_FLAG_CODE
, CON.THIRD_PARTY_PAY_FLAG THIRD_PARTY_PAY_FLAG_CODE
, CON.BENEFICIARY_FLAG BENEFICIARY_FLAG_CODE
, CON.BONDHOLDER_FLAG BONDHOLDER_FLAG_CODE
, CON.PERSONAL_FLAG PERSONAL_FLAG_CODE
, CON.RLTD_PER_RSDS_W_DSGNTR_FLAG RD_P_RSDS_W_DSR_FLAG_CODE
, CON.CONT_INFORMATION_CATEGORY CONT_INFORMATION_CATEGORY
, CON.CONT_INFORMATION1 CONT_INFORMATION1
, CON.CONT_INFORMATION2 CONT_INFORMATION2
, CON.CONT_INFORMATION3 CONT_INFORMATION3
, CON.CONT_INFORMATION4 CONT_INFORMATION4
, CON.CONT_INFORMATION5 CONT_INFORMATION5
, CON.CONT_INFORMATION6 CONT_INFORMATION6
, CON.CONT_INFORMATION7 CONT_INFORMATION7
, CON.CONT_INFORMATION8 CONT_INFORMATION8
, CON.CONT_INFORMATION9 CONT_INFORMATION9
, CON.CONT_INFORMATION10 CONT_INFORMATION10
, CON.CONT_INFORMATION11 CONT_INFORMATION11
, CON.CONT_INFORMATION12 CONT_INFORMATION12
, CON.CONT_INFORMATION13 CONT_INFORMATION13
, CON.CONT_INFORMATION14 CONT_INFORMATION14
, CON.CONT_INFORMATION15 CONT_INFORMATION15
, CON.CONT_INFORMATION16 CONT_INFORMATION16
, CON.CONT_INFORMATION17 CONT_INFORMATION17
, CON.CONT_INFORMATION18 CONT_INFORMATION18
, CON.CONT_INFORMATION19 CONT_INFORMATION19
, CON.CONT_INFORMATION20 CONT_INFORMATION20
, '_DF:PER:PER_CONTACTS:CON'
, HR_API.RETURN_LEGISLATION_CODE(CON.BUSINESS_GROUP_ID) LEGISLATION_CODE
, CON.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CON.CONTACT_PERSON_ID CONTACT_PERSON_ID
, CON.CONTACT_RELATIONSHIP_ID CONTACT_RELATIONSHIP_ID
, CON.PERSON_ID PERSON_ID
, CON.START_LIFE_REASON_ID START_LIFE_REASON_ID
, CON.END_LIFE_REASON_ID END_LIFE_REASON_ID
, CON.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CON.LAST_UPDATED_BY LAST_UPDATED_BY
, CON.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CON.CREATED_BY CREATED_BY
, CON.CREATION_DATE CREATION_DATE
, CASE WHEN (CON.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CON.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_CONTACT_RELATIONSHIPS CON WITH READ ONLY