DBA Data[Home] [Help]

APPS.IBY_PAYINSTR_PUB dependencies on CE_PAYMENT_DOCUMENTS

Line 83: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.

79:
80: /*-- processing criteria --*/
81: p_processing_type IN IBY_PAYMENT_PROFILES.
82: processing_type%TYPE,
83: p_pmt_document_id IN CE_PAYMENT_DOCUMENTS.
84: payment_document_id%TYPE,
85: p_printer_name IN VARCHAR2,
86: p_print_now_flag IN VARCHAR2,
87: p_transmit_now_flag IN VARCHAR2,

Line 524: from ce_payment_documents

520: APP_EXCEPTION.RAISE_EXCEPTION;
521: ELSE
522: select count(payment_document_id)
523: into l_valid_pay_doc
524: from ce_payment_documents
525: where payment_document_id = p_pmt_document_id
526: and internal_bank_account_id = p_internal_bank_account_id;
527:
528: IF(l_valid_pay_doc < 1) THEN

Line 558: FROM ce_payment_documents pdoc

554: INTO l_pmts_invalid_pdoc
555: FROM iby_payments_all pmts
556: WHERE pmts.payment_service_request_id = p_payreq_id
557: and pmts.internal_bank_account_id <> (SELECT pdoc.internal_bank_account_id
558: FROM ce_payment_documents pdoc
559: WHERE pdoc.payment_document_id = p_pmt_document_id);
560:
561:
562: