APPS.JE_ES_WHTAX dependencies on AP_INVOICE_PAYMENTS_ALL

Line 585: FROM ap_invoice_payments_all aip,

581: l_payments_count NUMBER := 0;
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

Line 892: ap_invoice_payments_all invpay,

888: awt.tax_name
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,

Line 1040: ap_invoice_payments_all invpay,

1036: awt.tax_name
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,

Line 1202: ap_invoice_payments_all invpay,

1198: awt.tax_name
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,

Line 1316: ap_invoice_payments_all invpay,

1312: awt.tax_name
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,

Line 1447: ap_invoice_payments_all invpay,

1443: awt.tax_name
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,

Line 1591: ap_invoice_payments_all invpay,

1587: awt.tax_name
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,

Line 1968: from ap_invoice_payments_all invpay,

1964: begin
1965: if p_fetch_pi_flag = 'P' then
1966: select min(dist.withholding_tax_code_id), max(invpay.accounting_date)
1967: into l_tax_code_id, l_accounting_date
1968: from ap_invoice_payments_all invpay,
1969: ap_invoice_distributions_all dist
1970: where dist.invoice_id = p_fetch_invoice_id
1971: and invpay.invoice_id = dist.invoice_id
1972: and dist.line_type_lookup_code = 'AWT'