DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 8105: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;

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

Line 8106: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;

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
8109:
8110: /*

Line 8207: IBY_EXTERNAL_PAYEES_ALL ep

8203: INTO
8204: l_trxn_handling
8205: FROM
8206: IBY_DOCS_PAYABLE_ALL doc,
8207: IBY_EXTERNAL_PAYEES_ALL ep
8208: WHERE
8209: doc.document_payable_id = p_document_id
8210: AND doc.ext_payee_id = ep.ext_payee_id
8211: ;

Line 8277: IBY_EXTERNAL_PAYEES_ALL ep

8273: INTO
8274: l_edi_pmt_format
8275: FROM
8276: IBY_DOCS_PAYABLE_ALL doc,
8277: IBY_EXTERNAL_PAYEES_ALL ep
8278: WHERE
8279: doc.document_payable_id = p_document_id
8280: AND doc.ext_payee_id = ep.ext_payee_id
8281: ;