APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on HZ_CONTACT_POINTS

Line 7950: l_bank_edi_id_number HZ_CONTACT_POINTS.edi_id_number%TYPE;

7946: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7947: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7948:
7949: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
7950: l_bank_edi_id_number HZ_CONTACT_POINTS.edi_id_number%TYPE;
7951: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;
7952: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;
7953:
7954: BEGIN

Line 7990: HZ_CONTACT_POINTS edi

7986: FROM
7987: IBY_DOCS_PAYABLE_ALL doc,
7988: CE_BANK_BRANCHES_V abb,
7989: CE_BANK_ACCOUNTS cba,
7990: HZ_CONTACT_POINTS edi
7991: WHERE
7992: doc.document_payable_id = p_document_id
7993: AND doc.internal_bank_account_id = cba.bank_account_id
7994: AND cba.bank_branch_id = abb.branch_party_id