DBA Data[Home] [Help]

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on CE_PAYMENT_DOCUMENTS

Line 131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;

127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
128: l_processing_type iby_payment_profiles.processing_type%TYPE;
129: l_print_instr_immed_flag iby_payment_profiles.print_instruction_immed_flag%TYPE;
130: l_default_printer iby_payment_profiles.default_printer%TYPE;
131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;
132: l_bills_payable iby_payment_methods_vl.support_bills_payable_flag%TYPE;
133: l_maturity_date_offset_days iby_payment_methods_vl.maturity_date_offset_days%TYPE;
134: l_maturity_date ap_checks.future_pay_due_date%TYPE;
135: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;

Line 880: FROM CE_PAYMENT_DOCUMENTS

876: BEGIN
877:
878: SELECT payment_document_id
879: INTO l_payment_document_id
880: FROM CE_PAYMENT_DOCUMENTS
881: WHERE payment_document_id = p_payment_document_id
882: AND internal_bank_account_id = p_internal_bank_acct_id
883: AND payment_instruction_id IS NULL;
884: