DBA Data[Home] [Help]

APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on IBY_FD_PAYMENTS_V

Line 70: FROM iby_fd_payments_v

66: CURSOR c_void_certificates (P_payment_Id IN Number) IS
67: SELECT payment_instruction_id,
68: --paper_document_number
69: nvl(paper_document_number,payment_reference_number) check_number --bug10012521
70: FROM iby_fd_payments_v
71: WHERE payment_id = p_payment_id;
72:
73: ------------------------------
74: BEGIN

Line 245: FROM IBY_FD_PAYMENTS_V ipmt,

241: ipmt.payment_date withholding_date,
242: atc.name tax_name,
243: docs.legal_entity_id legal_entity_id
244: , aid.org_id --bug 14798548
245: FROM IBY_FD_PAYMENTS_V ipmt,
246: CE_BANK_ACCOUNTS aba,
247: IBY_FD_DOCS_PAYABLE_V docs,
248: AP_TAX_CODES_ALL atc,
249: AP_INVOICE_DISTRIBUTIONS_ALL aid,

Line 290: FROM iby_fd_payments_v ipmt,

286: ipmt.payment_date withholding_date,
287: atc.name tax_name,
288: docs.legal_entity_id legal_entity_id
289: , aid.org_id --bug 14798548
290: FROM iby_fd_payments_v ipmt,
291: ce_bank_accounts aba,
292: iby_fd_docs_payable_v docs,
293: ap_tax_codes_all atc,
294: AP_AWT_TEMP_DISTRIBUTIONS_ALL aid,