APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_TAXES_B

Line 1772: index(taxes,ZX_TAXES_B_U2) */

1768: ,ACCOUNT_SOURCE_TAX_RATE_ID
1769: )
1770: (SELECT /*+ ROWID(inv) NO_EXPAND ORDERED
1771: use_nl(fnd_curr,ap_dists,ap_dists1,lines1,rates,regimes,taxes,status,ptp)
1772: index(taxes,ZX_TAXES_B_U2) */
1773: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
1774: ,200 APPLICATION_ID
1775: ,'AP_INVOICES' ENTITY_CODE
1776: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,

Line 2076: zx_taxes_b taxes,

2072: ap_invoice_lines_all lines1,
2073: ap_invoice_lines_all lines,
2074: zx_rates_b rates,
2075: zx_regimes_b regimes,
2076: zx_taxes_b taxes,
2077: zx_status_b status,
2078: zx_party_tax_profile ptp
2079: WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
2080: AND fnd_curr.currency_code = inv.invoice_currency_code

Line 3897: index(taxes,ZX_TAXES_B_U2) */

3893: ,ACCOUNT_SOURCE_TAX_RATE_ID
3894: )
3895: (SELECT /*+ ROWID(inv) NO_EXPAND ORDERED
3896: use_nl(fnd_curr,ap_dists,ap_dists1,lines1,rates,regimes,taxes,status,ptp)
3897: index(taxes,ZX_TAXES_B_U2) */
3898: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3899: ,200 APPLICATION_ID
3900: ,'AP_INVOICES' ENTITY_CODE
3901: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,

Line 4202: zx_taxes_b taxes,

4198: ap_invoice_lines_all lines1,
4199: ap_invoice_lines_all lines,
4200: zx_rates_b rates,
4201: zx_regimes_b regimes,
4202: zx_taxes_b taxes,
4203: zx_status_b status,
4204: zx_party_tax_profile ptp
4205: WHERE zxvalerr.other_doc_application_id = 200
4206: AND inv.invoice_id = zxvalerr.other_doc_trx_id