DBA Data[Home] [Help]

APPS.HZ_BANK_PUB dependencies on HZ_CONTACT_POINTS

Line 579: FROM hz_contact_points hcp,

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) =

Line 597: FROM hz_contact_points hcp,

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,