[Home] [Help]
683: fnd_lookups fl,
684: ap_invoices_all inv,
685: ap_invoice_lines_all line,
686: ap_invoice_distributions_all dist,
687: ap_tax_codes_all atc,
688: ap_awt_tax_rates_all awt,
689: (SELECT distinct person_id
690: ,national_identifier
691: FROM PER_ALL_PEOPLE_F) papf
737: and dist2.line_type_lookup_code = 'AWT'
738: and dist2.withholding_tax_code_id in
739: -- Bug 2019586: Column name should be tax_id.
740: -- (select tax_code_id from ap_tax_codes
741: (select tax_id from ap_tax_codes_all
742: where vat_transaction_type = p_wht_tax_type))
743: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
744: decode(nvl(v.employee_id,-1),-1,'01','00'),
745: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),
762: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
763: FROM fnd_lookups fl,
764: po_vendors v,
765: po_vendor_sites_all vs,
766: ap_tax_codes_all atc,
767: ap_awt_tax_rates_all awt,
768: ap_invoices_all inv,
769: ap_invoice_lines_all line,
770: ap_invoice_distributions_all dist,
841: and dist2.line_type_lookup_code = 'AWT'
842: and dist2.withholding_tax_code_id in
843: -- Bug 2019586: Column name should be tax_id.
844: -- (select tax_code_id from ap_tax_codes
845: (select tax_id from ap_tax_codes_all
846: where vat_transaction_type = p_wht_tax_type))
847: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
848: decode(nvl(v.employee_id,-1),-1,'01','00'),
849: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),
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,
898: ap_invoice_lines_all line,
959: and dist2.withholding_tax_code_id in
960: -- Bug 2019586: Column name should be tax_id.
961: -- (select tax_code_id from ap_tax_codes
962: (select tax_id
963: from ap_tax_codes_all
964: where vat_transaction_type = p_wht_tax_type))
965: AND NOT EXISTS ( select dist2.invoice_id
966: from ap_invoice_distributions_all dist2
967: where inv.invoice_id = dist2.invoice_id
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,
1046: ap_invoice_lines_all line,
1126: and dist2.withholding_tax_code_id in
1127: -- Bug 2019586: Column name should be tax_id.
1128: -- (select tax_code_id from ap_tax_codes
1129: (select tax_id
1130: from ap_tax_codes_all
1131: where vat_transaction_type = p_wht_tax_type))
1132: AND NOT EXISTS ( select dist2.invoice_id
1133: from ap_invoice_distributions_all dist2
1134: where inv.invoice_id = dist2.invoice_id
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,
1208: ap_invoice_lines_all line,
1267: and dist2.withholding_tax_code_id in
1268: -- Bug 2019586: Column name should be tax_id.
1269: -- (select tax_code_id from ap_tax_codes
1270: (select tax_id
1271: from ap_tax_codes_all
1272: where vat_transaction_type = p_wht_tax_type))
1273: AND NOT EXISTS ( select dist2.invoice_id
1274: from ap_invoice_distributions_all dist2
1275: where inv.invoice_id = dist2.invoice_id
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,
1322: ap_invoice_lines_all line,
1401: and dist2.withholding_tax_code_id in
1402: -- Bug 2019586: Column name should be tax_id.
1403: -- (select tax_code_id from ap_tax_codes
1404: (select tax_id
1405: from ap_tax_codes_all
1406: where vat_transaction_type = p_wht_tax_type))
1407: AND NOT EXISTS ( select dist2.invoice_id
1408: from ap_invoice_distributions_all dist2
1409: where inv.invoice_id = dist2.invoice_id
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,
1453: ap_invoice_lines_all line,
1510: and dist2.withholding_tax_code_id in
1511: -- Bug 2019586: Column name should be tax_id.
1512: -- (select tax_code_id from ap_tax_codes
1513: (select tax_id
1514: from ap_tax_codes_all
1515: where vat_transaction_type = p_wht_tax_type))
1516: AND EXISTS ( select dist2.invoice_id
1517: from ap_invoice_distributions_all dist2
1518: where inv.invoice_id = dist2.invoice_id
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,
1597: ap_invoice_lines_all line,
1674: and dist2.withholding_tax_code_id in
1675: -- Bug 2019586: Column name should be tax_id.
1676: -- (select tax_code_id from ap_tax_codes
1677: (select tax_id
1678: from ap_tax_codes_all
1679: where vat_transaction_type = p_wht_tax_type))
1680: AND EXISTS ( select dist2.invoice_id
1681: from ap_invoice_distributions_all dist2
1682: where inv.invoice_id = dist2.invoice_id
1739: awt.tax_name
1740: FROM fnd_lookups fl,
1741: po_vendors v,
1742: po_vendor_sites_all vs,
1743: ap_tax_codes_all atc,
1744: ap_awt_tax_rates_all awt,
1745: fnd_document_sequences seq,
1746: ap_invoices_all inv,
1747: ap_invoice_lines_all line,
1798: and dist2.line_type_lookup_code = 'AWT'
1799: and dist2.withholding_tax_code_id in
1800: -- Bug 2019586: Column name should be tax_id.
1801: -- (select tax_code_id from ap_tax_codes
1802: (select tax_id from ap_tax_codes_all
1803: where vat_transaction_type = p_wht_tax_type))
1804: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
1805: decode(nvl(v.employee_id,-1),-1,'01','00'),
1806: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),
1844: awt.tax_name
1845: FROM fnd_lookups fl,
1846: po_vendors v,
1847: po_vendor_sites_all vs,
1848: ap_tax_codes_all atc,
1849: ap_awt_tax_rates_all awt,
1850: fnd_document_sequences seq,
1851: ap_invoices_all inv,
1852: ap_invoice_lines_all line,
1923: and dist2.line_type_lookup_code = 'AWT'
1924: and dist2.withholding_tax_code_id in
1925: -- Bug 2019586: Column name should be tax_id.
1926: -- (select tax_code_id from ap_tax_codes
1927: (select tax_id from ap_tax_codes_all
1928: where vat_transaction_type = p_wht_tax_type))
1929: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
1930: decode(nvl(v.employee_id,-1),-1,'01','00'),
1931: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),
2003: end;
2004: begin
2005: select awt.tax_rate, awt.tax_name
2006: into l_tax_rate, l_tax_name
2007: from ap_tax_codes_all atc, ap_awt_tax_rates_all awt
2008: where atc.name = awt.tax_name(+)
2009: and atc.tax_id = l_tax_code_id
2010: and l_accounting_date between nvl(awt.start_date,l_accounting_date)
2011: and nvl(awt.end_date,l_accounting_date);