APPS.JE_ES_WHTAX dependencies on AP_INVOICE_PAYMENTS_ALL

Line 590: FROM ap_invoice_payments_all aip,

586: l_payments_count NUMBER := 0;
587: BEGIN
588: SELECT COUNT(aip.invoice_payment_id)
589: INTO l_payments_count
590: FROM ap_invoice_payments_all aip,
591: ap_checks_all ac
592: WHERE aip.invoice_id = l_invoice_id
593: AND ac.legal_entity_id = nvl(l_legal_entity_id, ac.legal_entity_id)
594: -- bug 5207771: Removed org_id condition

Line 941: ap_invoice_payments_all invpay,

937: 'N'
938: FROM fnd_lookups fl,
939: po_vendors v,
940: po_vendor_sites_all vs,
941: ap_invoice_payments_all invpay,
942: ap_checks_all checks,
943: ap_tax_codes_all atc,
944: ap_awt_tax_rates_all awt,
945: fnd_document_sequences seq,

Line 1120: ap_invoice_payments_all invpay,

1116: 'Y'
1117: FROM fnd_lookups fl,
1118: po_vendors v,
1119: po_vendor_sites_all vs,
1120: ap_invoice_payments_all invpay,
1121: ap_checks_all checks,
1122: ap_tax_codes_all atc,
1123: ap_awt_tax_rates_all awt,
1124: fnd_document_sequences seq,

Line 1312: ap_invoice_payments_all invpay,

1308: 'N'
1309: FROM fnd_lookups fl,
1310: po_vendors v,
1311: po_vendor_sites_all vs,
1312: ap_invoice_payments_all invpay,
1313: ap_checks_all checks,
1314: ap_tax_codes_all atc,
1315: ap_awt_tax_rates_all awt,
1316: fnd_document_sequences seq,

Line 1488: ap_invoice_payments_all invpay,

1484: 'Y'
1485: FROM fnd_lookups fl,
1486: po_vendors v,
1487: po_vendor_sites_all vs,
1488: ap_invoice_payments_all invpay,
1489: ap_checks_all checks,
1490: ap_tax_codes_all atc,
1491: ap_awt_tax_rates_all awt,
1492: fnd_document_sequences seq,

Line 1678: ap_invoice_payments_all invpay,

1674: 'N'
1675: FROM fnd_lookups fl,
1676: po_vendors v,
1677: po_vendor_sites_all vs,
1678: ap_invoice_payments_all invpay,
1679: ap_checks_all checks,
1680: ap_tax_codes_all atc,
1681: ap_awt_tax_rates_all awt,
1682: fnd_document_sequences seq,

Line 1852: ap_invoice_payments_all invpay,

1848: 'Y'
1849: FROM fnd_lookups fl,
1850: po_vendors v,
1851: po_vendor_sites_all vs,
1852: ap_invoice_payments_all invpay,
1853: ap_checks_all checks,
1854: ap_tax_codes_all atc,
1855: ap_awt_tax_rates_all awt,
1856: fnd_document_sequences seq,

Line 2314: select min(dist.withholding_tax_code_id),(select max(accounting_date) from ap_invoice_payments_all where invoice_id=p_fetch_invoice_id)

2310: if p_awt_invoice_payment_id is null then -- Bug 12616975
2311:
2312:
2313: -- select min(dist.withholding_tax_code_id), max(invpay.accounting_date) -- Bug 12616975
2314: select min(dist.withholding_tax_code_id),(select max(accounting_date) from ap_invoice_payments_all where invoice_id=p_fetch_invoice_id)
2315: into l_tax_code_id, l_accounting_date
2316: from -- ap_invoice_payments_all invpay,
2317: ap_invoice_distributions_all dist
2318: where dist.invoice_id = p_fetch_invoice_id

Line 2316: from -- ap_invoice_payments_all invpay,

2312:
2313: -- select min(dist.withholding_tax_code_id), max(invpay.accounting_date) -- Bug 12616975
2314: select min(dist.withholding_tax_code_id),(select max(accounting_date) from ap_invoice_payments_all where invoice_id=p_fetch_invoice_id)
2315: into l_tax_code_id, l_accounting_date
2316: from -- ap_invoice_payments_all invpay,
2317: ap_invoice_distributions_all dist
2318: where dist.invoice_id = p_fetch_invoice_id
2319: --and invpay.invoice_id = dist.invoice_id -- Bug 12616975 takes cross product
2320: and dist.line_type_lookup_code = 'AWT'

Line 2338: from ap_invoice_payments_all invpay,

2334: else
2335:
2336: select min(dist.withholding_tax_code_id), max(invpay.accounting_date)
2337: into l_tax_code_id, l_accounting_date
2338: from ap_invoice_payments_all invpay,
2339: ap_invoice_distributions_all dist
2340: where dist.invoice_id = p_fetch_invoice_id
2341: and invpay.invoice_id = dist.invoice_id
2342: and invpay.INVOICE_PAYMENT_ID = dist.AWT_INVOICE_PAYMENT_ID -- Bug 12616975