DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on HZ_CONTACT_POINTS

Line 7876: l_bank_edi_id_number HZ_CONTACT_POINTS.edi_id_number%TYPE;

7872: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7873: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7874:
7875: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
7876: l_bank_edi_id_number HZ_CONTACT_POINTS.edi_id_number%TYPE;
7877: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;
7878: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;
7879:
7880: BEGIN

Line 7916: HZ_CONTACT_POINTS edi

7912: FROM
7913: IBY_DOCS_PAYABLE_ALL doc,
7914: CE_BANK_BRANCHES_V abb,
7915: CE_BANK_ACCOUNTS cba,
7916: HZ_CONTACT_POINTS edi
7917: WHERE
7918: doc.document_payable_id = p_document_id
7919: AND doc.internal_bank_account_id = cba.bank_account_id
7920: AND cba.bank_branch_id = abb.branch_party_id