APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_RATES_B

Line 2057: ,(SELECT tax_rate_id FROM zx_rates_b

2053: ,NVL(rates.def_rec_settlement_option_code,
2054: taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
2055: --,TAX_JURISDICTION_ID
2056: ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
2057: ,(SELECT tax_rate_id FROM zx_rates_b
2058: WHERE tax_rate_code = 'AD_HOC_RECOVERY'
2059: AND rate_type_code = 'RECOVERY'
2060: AND tax_regime_code = rates.tax_regime_code
2061: AND tax = rates.tax

Line 2074: zx_rates_b rates,

2070: ap_invoice_distributions_all ap_dists,
2071: ap_invoice_distributions_all ap_dists1,
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

Line 4182: ,(SELECT tax_rate_id FROM zx_rates_b

4178: ,NVL(rates.def_rec_settlement_option_code,
4179: taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
4180: --,TAX_JURISDICTION_ID
4181: ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
4182: ,(SELECT tax_rate_id FROM zx_rates_b
4183: WHERE tax_rate_code = 'AD_HOC_RECOVERY'
4184: AND rate_type_code = 'RECOVERY'
4185: AND tax_regime_code = rates.tax_regime_code
4186: AND tax = rates.tax

Line 4200: zx_rates_b rates,

4196: ap_invoice_distributions_all ap_dists,
4197: ap_invoice_distributions_all ap_dists1,
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