APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_SCO_RATES

Line 105: zx_sco_rates rates

101: acr.tax_rate_code,
102: rates.tax_rate_id,
103: acr.tax_class
104: FROM zx_account_rates acr,
105: zx_sco_rates rates
106: WHERE rates.tax_regime_code = acr.tax_regime_code
107: AND rates.tax = acr.tax
108: AND rates.tax_status_code = acr.tax_status_code
109: AND rates.tax_rate_code = acr.tax_rate_code

Line 134: zx_sco_rates rates

130: acr.tax_rate_code,
131: rates.tax_rate_id,
132: acr.tax_class
133: FROM zx_account_rates acr,
134: zx_sco_rates rates
135: WHERE rates.tax_regime_code = acr.tax_regime_code
136: AND rates.tax = acr.tax
137: AND rates.tax_status_code = acr.tax_status_code
138: AND rates.tax_rate_code = acr.tax_rate_code

Line 829: FROM zx_sco_rates rates,

825: p_trx_date DATE)
826: IS
827: SELECT rates.tax_rate_id,
828: rates.tax_class
829: FROM zx_sco_rates rates,
830: zx_taxes_b taxes
831: WHERE rates.tax_rate_code = p_tax_rate_code
832: AND p_trx_date >= rates.effective_from
833: AND p_trx_date <= NVL(rates.effective_to, p_trx_date)

Line 854: FROM zx_sco_rates rates,

850: p_tax_class VARCHAR2,
851: p_trx_date DATE)
852: IS
853: SELECT rates.tax_rate_id
854: FROM zx_sco_rates rates,
855: zx_taxes_b taxes
856: WHERE rates.tax_rate_code = p_tax_rate_code
857: AND p_trx_date >= rates.effective_from
858: AND p_trx_date <= NVL(rates.effective_to, p_trx_date)