APPS.JE_ES_WHTAX dependencies on AP_AWT_TAX_RATES_ALL

Line 698: ap_awt_tax_rates_all awt,

694: ap_invoices_all inv,
695: ap_invoice_lines_all line,
696: ap_invoice_distributions_all dist,
697: ap_tax_codes_all atc,
698: ap_awt_tax_rates_all awt,
699: (SELECT distinct person_id
700: ,national_identifier
701: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
702: WHERE v.vendor_id = vs.vendor_id

Line 794: ap_awt_tax_rates_all awt,

790: FROM fnd_lookups fl,
791: po_vendors v,
792: po_vendor_sites_all vs,
793: ap_tax_codes_all atc,
794: ap_awt_tax_rates_all awt,
795: ap_invoices_all inv,
796: ap_invoice_lines_all line,
797: ap_invoice_distributions_all dist,
798: (SELECT distinct person_id

Line 944: ap_awt_tax_rates_all awt,

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,
946: ap_invoices_all inv,
947: ap_invoice_lines_all line,
948: ap_invoice_distributions_all dist,

Line 1123: ap_awt_tax_rates_all awt,

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,
1125: ap_invoices_all inv,
1126: ap_invoice_lines_all line,
1127: ap_invoice_distributions_all dist,

Line 1315: ap_awt_tax_rates_all awt,

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,
1317: ap_invoices_all inv,
1318: ap_invoice_lines_all line,
1319: ap_invoice_distributions_all dist,

Line 1491: ap_awt_tax_rates_all awt,

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,
1493: ap_invoices_all inv,
1494: ap_invoice_lines_all line,
1495: ap_invoice_distributions_all dist,

Line 1681: ap_awt_tax_rates_all awt,

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,
1683: ap_invoices_all inv,
1684: ap_invoice_lines_all line,
1685: ap_invoice_distributions_all dist,

Line 1855: ap_awt_tax_rates_all awt,

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,
1857: ap_invoices_all inv,
1858: ap_invoice_lines_all line,
1859: ap_invoice_distributions_all dist,

Line 2033: ap_awt_tax_rates_all awt,

2029: FROM fnd_lookups fl,
2030: po_vendors v,
2031: po_vendor_sites_all vs,
2032: ap_tax_codes_all atc,
2033: ap_awt_tax_rates_all awt,
2034: fnd_document_sequences seq,
2035: ap_invoices_all inv,
2036: ap_invoice_lines_all line,
2037: ap_invoice_distributions_all dist,

Line 2168: ap_awt_tax_rates_all awt,

2164: FROM fnd_lookups fl,
2165: po_vendors v,
2166: po_vendor_sites_all vs,
2167: ap_tax_codes_all atc,
2168: ap_awt_tax_rates_all awt,
2169: fnd_document_sequences seq,
2170: ap_invoices_all inv,
2171: ap_invoice_lines_all line,
2172: ap_invoice_distributions_all dist,

Line 2399: from ap_tax_codes_all atc, ap_awt_tax_rates_all awt

2395:
2396:
2397: select awt.tax_rate, awt.tax_name
2398: into l_tax_rate, l_tax_name
2399: from ap_tax_codes_all atc, ap_awt_tax_rates_all awt
2400: where atc.name = awt.tax_name(+)
2401: and atc.tax_id = l_tax_code_id
2402: and l_accounting_date between nvl(awt.start_date,l_accounting_date)
2403: and nvl(awt.end_date,l_accounting_date)