DBA Data[Home] [Help]

APPS.HZ_BANK_PUB dependencies on HZ_CONTACT_POINTS

Line 567: FROM hz_contact_points hcp,

563: -- cursor used to determine uniqueness of the EDI contact point across
564: -- bank parties.
565: CURSOR c_uniqueptyedi IS
566: SELECT 1
567: FROM hz_contact_points hcp,
568: hz_code_assignments hca
569: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
570: AND NVL(hcp.edi_ece_tp_location_code,
571: p_edi_rec.edi_ece_tp_location_code) =

Line 585: FROM hz_contact_points hcp,

581: -- cursor used to determine uniqueness of the EDI contact point across
582: -- bank party sites.
583: CURSOR c_uniquepsedi IS
584: SELECT 1
585: FROM hz_contact_points hcp,
586: hz_party_sites hps,
587: hz_code_assignments hca
588: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
589: AND NVL(hcp.edi_ece_tp_location_code,