DBA Data[Home] [Help]

APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 202: ap_invoice_payments_all aipa ,

198: jattt.vendor_id vendor_id ,
199: jattt.vendor_site_id vendor_site_id
200: from
201: ap_checks_all aca ,
202: ap_invoice_payments_all aipa ,
203: ap_invoices_all aia ,
204: jai_ap_tds_thhold_trxs jattt,
205: JAI_CMN_TAXES_ALL jitc
206: where

Line 273: ap_invoice_payments_all aipa,

269: lv_attribute_category) context ,
270: aia.attribute1 parent_invoice_id
271: from
272: ap_checks_all aca,
273: ap_invoice_payments_all aipa,
274: ap_invoices_all aia
275: where aca.check_id = aipa.check_id
276: and aipa.invoice_id = aia.invoice_id
277: and aia.source = lv_source

Line 475: ap_invoice_payments_all aipa

471: aca.amount check_amount,
472: aipa.invoice_payment_id invoice_payment_id
473: from
474: ap_checks_all aca,
475: ap_invoice_payments_all aipa
476: where aca.check_id = aipa.check_id
477: and aipa.invoice_id = pn_invoice_id;
478:
479: cursor c_get_total_tax_basis ( cp_invoice_id number) is /*Added by nprashar for Bug # 6774129*/

Line 573: ap_invoice_payments_all aipa ,

569: select
570: aca.check_id check_id
571: from
572: ap_checks_all aca ,
573: ap_invoice_payments_all aipa ,
574: ap_invoices_all aia ,
575: jai_ap_tds_thhold_trxs jattt,
576: JAI_CMN_TAXES_ALL jitc
577: where