DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SCO_RATES_B_V

Line 2348: FROM ZX_SCO_RATES_B_V rate

2344: IS
2345: SELECT rate.tax_rate_code,
2346: rate.rate_type_code,
2347: rate.tax_rate_id
2348: FROM ZX_SCO_RATES_B_V rate
2349: WHERE rate.tax_regime_code = c_tax_regime_code
2350: -- AND rate.default_rate_flag = 'Y'
2351: AND rate.active_flag = 'Y'
2352: AND rate.tax = c_tax

Line 2626: FROM ZX_SCO_RATES_B_V rate

2622: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_rate_code(ptnr_tax_line_index),
2623: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.rate_type_code(ptnr_tax_line_index),
2624: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_rate_id(ptnr_tax_line_index)
2625: -- FROM ZX_SCO_RATES rate -- Bug#5395227
2626: FROM ZX_SCO_RATES_B_V rate
2627: WHERE rate.tax_regime_code = p_tax_regime_code
2628: AND rate.default_rate_flag = 'Y'
2629: AND rate.active_flag = 'Y'
2630: AND rate.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)