APPS.JE_ITWHYE_AP_PKG dependencies on AP_INVOICE_PAYMENTS

Line 289: ap_invoice_payments_all aip,

285: AND dist1.line_type_lookup_code = 'ITEM'
286: -- AND dist1.awt_group_id IS NULL
287: group by dist1.invoice_id)dist
288: ,ap_invoices_all inv,
289: ap_invoice_payments_all aip,
290: ap_checks_all checks,
291: zx_party_tax_profile zpt --Bug 14136822
292: WHERE inv.legal_entity_id = p_legal_entity_id
293: AND inv.invoice_id = dist.invoice_id

Line 310: FROM ap_invoice_payments_all aip_sub

306: AND checks.void_date IS NULL
307: AND aip.accounting_date BETWEEN cp_year_start_date AND cp_year_end_date
308: AND aip.invoice_payment_id =
309: (SELECT MAX (aip_sub.invoice_payment_id)
310: FROM ap_invoice_payments_all aip_sub
311: WHERE aip_sub.invoice_id = inv.invoice_id
312: AND aip_sub.accounting_date BETWEEN cp_year_start_date
313: AND cp_year_end_date
314: GROUP BY aip_sub.invoice_id)

Line 317: FROM ap_invoice_payments_all aip_sub2,

313: AND cp_year_end_date
314: GROUP BY aip_sub.invoice_id)
315: AND EXISTS (
316: SELECT 1
317: FROM ap_invoice_payments_all aip_sub2,
318: ap_invoice_distributions_all dist
319: WHERE aip_sub2.invoice_payment_id =
320: DECODE (dist.line_type_lookup_code,
321: 'AWT', dist.awt_invoice_payment_id,

Line 544: from ap_invoice_payments

540: select sum(amount),
541: sum(nvl(payment_base_amount, amount))
542: into l_amount_etrd,
543: l_amount_paid
544: from ap_invoice_payments
545: where invoice_id = cur_withholding_extract_rec.invoice_id
546: and accounting_date between cp_year_start_date AND cp_year_end_date
547: group by invoice_id;
548:

Line 575: from ap_invoice_payments pay

571: l_inv_whtot_etrd
572: from ap_invoice_distributions dist
573: where dist.invoice_id = cur_withholding_extract_rec.invoice_id
574: and exists (select 1
575: from ap_invoice_payments pay
576: where pay.invoice_payment_id = decode(dist.line_type_lookup_code,'AWT',
577: dist.awt_invoice_payment_id,pay.invoice_payment_id)
578: and pay.accounting_date between cp_year_start_date AND cp_year_end_date);
579: