1969: /* Below query checks for the duplicate contacts */
1970:
1971: SELECT Count(*) INTO l_duplicateRow
1972: FROM HZ_PARTIES HPC,
1973: HZ_CONTACT_POINTS HCPP,
1974: HZ_CONTACT_POINTS HCPE,
1975: HZ_RELATIONSHIPS HR
1976: WHERE HR.SUBJECT_ID = l_suppPartyId
1977: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1970:
1971: SELECT Count(*) INTO l_duplicateRow
1972: FROM HZ_PARTIES HPC,
1973: HZ_CONTACT_POINTS HCPP,
1974: HZ_CONTACT_POINTS HCPE,
1975: HZ_RELATIONSHIPS HR
1976: WHERE HR.SUBJECT_ID = l_suppPartyId
1977: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1978: AND HCPP.OWNER_TABLE_ID (+) = HR.PARTY_ID