APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on CE_BANK_BRANCHES_V

Line 7875: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;

7871: l_valid NUMBER := 0;
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:

Line 7877: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;

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
7881:

Line 7878: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;

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
7881:
7882: /*

Line 7914: CE_BANK_BRANCHES_V abb,

7910: l_bank_name,
7911: l_bank_branch_name
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

Line 8026: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;

8022: l_valid NUMBER := 0;
8023: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8024: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8025:
8026: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
8027: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
8028: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
8029:
8030: BEGIN

Line 8060: CE_BANK_BRANCHES_V cbb

8056: l_bank_branch_type
8057: FROM
8058: IBY_DOCS_PAYABLE_ALL doc,
8059: IBY_EXT_BANK_ACCOUNTS_V eba,
8060: CE_BANK_BRANCHES_V cbb
8061: WHERE
8062: doc.document_payable_id = p_document_id
8063: AND doc.external_bank_account_id = eba.ext_bank_account_id(+)
8064: AND eba.bank_party_id = cbb.bank_party_id(+)