APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_RATES_B

Line 2106: ,(SELECT tax_rate_id FROM zx_rates_b

2102: ,NVL(rates.def_rec_settlement_option_code,
2103: taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
2104: --,TAX_JURISDICTION_ID
2105: ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
2106: ,(SELECT tax_rate_id FROM zx_rates_b
2107: WHERE tax_rate_code = 'AD_HOC_RECOVERY'
2108: AND rate_type_code = 'RECOVERY'
2109: AND tax_regime_code = rates.tax_regime_code
2110: AND tax = rates.tax

Line 2123: zx_rates_b rates,

2119: ap_invoice_distributions_all ap_dists,
2120: ap_invoice_distributions_all ap_dists1,
2121: ap_invoice_lines_all lines1,
2122: ap_invoice_lines_all lines,
2123: zx_rates_b rates,
2124: zx_regimes_b regimes,
2125: zx_taxes_b taxes,
2126: zx_status_b status,
2127: zx_party_tax_profile ptp

Line 4249: ,(SELECT tax_rate_id FROM zx_rates_b

4245: ,NVL(rates.def_rec_settlement_option_code,
4246: taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
4247: --,TAX_JURISDICTION_ID
4248: ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
4249: ,(SELECT tax_rate_id FROM zx_rates_b
4250: WHERE tax_rate_code = 'AD_HOC_RECOVERY'
4251: AND rate_type_code = 'RECOVERY'
4252: AND tax_regime_code = rates.tax_regime_code
4253: AND tax = rates.tax

Line 4267: zx_rates_b rates,

4263: ap_invoice_distributions_all ap_dists,
4264: ap_invoice_distributions_all ap_dists1,
4265: ap_invoice_lines_all lines1,
4266: ap_invoice_lines_all lines,
4267: zx_rates_b rates,
4268: zx_regimes_b regimes,
4269: zx_taxes_b taxes,
4270: zx_status_b status,
4271: zx_party_tax_profile ptp