APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on CE_BANK_BRANCHES_V

Line 7949: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;

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

Line 7951: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;

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

Line 7952: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;

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
7955:
7956: /*

Line 7988: CE_BANK_BRANCHES_V abb,

7984: l_bank_name,
7985: l_bank_branch_name
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

Line 8104: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;

8100: l_valid NUMBER := 0;
8101: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8102: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8103:
8104: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
8105: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
8106: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
8107:
8108: BEGIN

Line 8138: CE_BANK_BRANCHES_V cbb

8134: l_bank_branch_type
8135: FROM
8136: IBY_DOCS_PAYABLE_ALL doc,
8137: IBY_EXT_BANK_ACCOUNTS_V eba,
8138: CE_BANK_BRANCHES_V cbb
8139: WHERE
8140: doc.document_payable_id = p_document_id
8141: AND doc.external_bank_account_id = eba.ext_bank_account_id(+)
8142: AND eba.bank_party_id = cbb.bank_party_id(+)