APPS.JE_ES_WHTAX dependencies on AP_AWT_TAX_RATES_ALL

Line 688: ap_awt_tax_rates_all awt,

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
692: WHERE v.vendor_id = vs.vendor_id

Line 767: ap_awt_tax_rates_all awt,

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,
771: (SELECT distinct person_id

Line 895: ap_awt_tax_rates_all awt,

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,
899: ap_invoice_distributions_all dist,

Line 1043: ap_awt_tax_rates_all awt,

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,
1047: ap_invoice_distributions_all dist,

Line 1205: ap_awt_tax_rates_all awt,

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,
1209: ap_invoice_distributions_all dist,

Line 1319: ap_awt_tax_rates_all awt,

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,
1323: ap_invoice_distributions_all dist,

Line 1450: ap_awt_tax_rates_all awt,

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,
1454: ap_invoice_distributions_all dist,

Line 1594: ap_awt_tax_rates_all awt,

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,
1598: ap_invoice_distributions_all dist,

Line 1744: ap_awt_tax_rates_all awt,

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,
1748: ap_invoice_distributions_all dist,

Line 1849: ap_awt_tax_rates_all awt,

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,
1853: ap_invoice_distributions_all dist,

Line 2007: from ap_tax_codes_all atc, ap_awt_tax_rates_all awt

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);