APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SCO_TAXES_B_V

Line 527: FROM ZX_SCO_TAXES_B_V

523: -- adding code to populate exemption details in partner calculated tax lines
524: BEGIN
525: SELECT TAX_ACCOUNT_SOURCE_TAX
526: INTO l_tax_account_source_tax
527: FROM ZX_SCO_TAXES_B_V
528: WHERE tax_regime_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind)
529: AND tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(p_ptnr_tax_line_ind)
530: AND ( ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_date(p_ptnr_tax_line_ind) >= effective_from
531: AND (ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_date(p_ptnr_tax_line_ind) <= effective_to

Line 2067: FROM ZX_SCO_TAXES_B_V -- Bug#5395227

2063: CURSOR currency_csr IS
2064: SELECT DISTINCT tax, -- Bug#5395227
2065: tax_currency_code,
2066: exchange_rate_type
2067: FROM ZX_SCO_TAXES_B_V -- Bug#5395227
2068: WHERE tax_regime_code = p_tax_regime_code;
2069:
2070: --Currencies can be passed at either the header level/line level
2071: CURSOR document_currency_csr IS

Line 2476: FROM ZX_SCO_TAXES_B_V

2472: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_id(ptnr_tax_line_index),
2473: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_type_code(ptnr_tax_line_index),
2474: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_currency_conversion_type(ptnr_tax_line_index)
2475: -- FROM ZX_SCO_TAXES -- Bug#5395227
2476: FROM ZX_SCO_TAXES_B_V
2477: WHERE tax_regime_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index)
2478: AND tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2479: AND rownum = 1
2480: ORDER BY subscription_level_code; -- Bug#5395227