[Home] [Help]
582: BEGIN
583: SELECT COUNT(aip.invoice_payment_id)
584: INTO l_payments_count
585: FROM ap_invoice_payments_all aip,
586: ap_checks_all ac
587: WHERE aip.invoice_id = l_invoice_id
588: AND ac.legal_entity_id = nvl(l_legal_entity_id, ac.legal_entity_id)
589: -- bug 5207771: Removed org_id condition
590: --and ac.org_id = nvl(l_org_id,ac.org_id)
889: FROM fnd_lookups fl,
890: po_vendors v,
891: po_vendor_sites_all vs,
892: ap_invoice_payments_all invpay,
893: ap_checks_all checks,
894: ap_tax_codes_all atc,
895: ap_awt_tax_rates_all awt,
896: fnd_document_sequences seq,
897: ap_invoices_all inv,
1037: FROM fnd_lookups fl,
1038: po_vendors v,
1039: po_vendor_sites_all vs,
1040: ap_invoice_payments_all invpay,
1041: ap_checks_all checks,
1042: ap_tax_codes_all atc,
1043: ap_awt_tax_rates_all awt,
1044: fnd_document_sequences seq,
1045: ap_invoices_all inv,
1199: FROM fnd_lookups fl,
1200: po_vendors v,
1201: po_vendor_sites_all vs,
1202: ap_invoice_payments_all invpay,
1203: ap_checks_all checks,
1204: ap_tax_codes_all atc,
1205: ap_awt_tax_rates_all awt,
1206: fnd_document_sequences seq,
1207: ap_invoices_all inv,
1313: FROM fnd_lookups fl,
1314: po_vendors v,
1315: po_vendor_sites_all vs,
1316: ap_invoice_payments_all invpay,
1317: ap_checks_all checks,
1318: ap_tax_codes_all atc,
1319: ap_awt_tax_rates_all awt,
1320: fnd_document_sequences seq,
1321: ap_invoices_all inv,
1444: FROM fnd_lookups fl,
1445: po_vendors v,
1446: po_vendor_sites_all vs,
1447: ap_invoice_payments_all invpay,
1448: ap_checks_all checks,
1449: ap_tax_codes_all atc,
1450: ap_awt_tax_rates_all awt,
1451: fnd_document_sequences seq,
1452: ap_invoices_all inv,
1588: FROM fnd_lookups fl,
1589: po_vendors v,
1590: po_vendor_sites_all vs,
1591: ap_invoice_payments_all invpay,
1592: ap_checks_all checks,
1593: ap_tax_codes_all atc,
1594: ap_awt_tax_rates_all awt,
1595: fnd_document_sequences seq,
1596: ap_invoices_all inv,