575: -- cursor used to determine uniqueness of the EDI contact point across
576: -- bank parties.
577: CURSOR c_uniqueptyedi IS
578: SELECT 1
579: FROM hz_contact_points hcp,
580: hz_code_assignments hca
581: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
582: AND NVL(hcp.edi_ece_tp_location_code,
583: p_edi_rec.edi_ece_tp_location_code) =
593: -- cursor used to determine uniqueness of the EDI contact point across
594: -- bank party sites.
595: CURSOR c_uniquepsedi IS
596: SELECT 1
597: FROM hz_contact_points hcp,
598: hz_party_sites hps,
599: hz_code_assignments hca
600: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
601: AND NVL(hcp.edi_ece_tp_location_code,