DBA Data[Home] [Help]

APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on AP_TAX_CODES

Line 248: AP_TAX_CODES_ALL atc,

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,
250: AP_INVOICE_PAYMENTS_ALL aip,
251: PO_VENDORS pv
252: WHERE ipmt.payment_instruction_id = p_payment_instruction_id

Line 293: ap_tax_codes_all atc,

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,
295: ap_selected_invoices_all api,
296: po_vendors pv
297: WHERE ipmt.payment_instruction_id = p_payment_instruction_id

Line 817: ap_tax_codes atc

813:
814: SELECT (jlts.calc_wh_amnt - jlts.act_wheld_amnt)
815: INTO v_amount
816: FROM jl_ar_ap_sup_awt_cr_lts jlts,
817: ap_tax_codes atc
818: WHERE
819: jlts.po_vendor_id = v_vendor_id
820: and jlts.awt_type_code = v_awt_type_code
821: and jlts.tax_id = atc.tax_id