APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 189: ap_invoice_payments_all aipa ,

185: jattt.vendor_id vendor_id ,
186: jattt.vendor_site_id vendor_site_id
187: from
188: ap_checks_all aca ,
189: ap_invoice_payments_all aipa ,
190: ap_invoices_all aia ,
191: jai_ap_tds_thhold_trxs jattt,
192: JAI_CMN_TAXES_ALL jitc
193: where

Line 260: ap_invoice_payments_all aipa,

256: lv_attribute_category) context ,
257: aia.attribute1 parent_invoice_id
258: from
259: ap_checks_all aca,
260: ap_invoice_payments_all aipa,
261: ap_invoices_all aia
262: where aca.check_id = aipa.check_id
263: and aipa.invoice_id = aia.invoice_id
264: and aia.source = lv_source

Line 462: ap_invoice_payments_all aipa

458: aca.amount check_amount,
459: aipa.invoice_payment_id invoice_payment_id
460: from
461: ap_checks_all aca,
462: ap_invoice_payments_all aipa
463: where aca.check_id = aipa.check_id
464: and aipa.invoice_id = pn_invoice_id;
465:
466: cursor c_get_total_tax_basis ( cp_invoice_id number) is /*Added by nprashar for Bug # 6774129*/

Line 560: ap_invoice_payments_all aipa ,

556: select
557: aca.check_id check_id
558: from
559: ap_checks_all aca ,
560: ap_invoice_payments_all aipa ,
561: ap_invoices_all aia ,
562: jai_ap_tds_thhold_trxs jattt,
563: JAI_CMN_TAXES_ALL jitc
564: where