DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SCO_TAXES_B_V

Line 436: FROM ZX_SCO_TAXES_B_V

432:
433: BEGIN
434: SELECT TAX_ACCOUNT_SOURCE_TAX
435: INTO l_tax_account_source_tax
436: FROM ZX_SCO_TAXES_B_V
437: WHERE tax_regime_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind) AND
438: tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(p_ptnr_tax_line_ind) AND
439: ( ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_date(p_ptnr_tax_line_ind) >= effective_from AND
440: ( ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_date(p_ptnr_tax_line_ind) <= effective_to OR effective_to IS NULL));

Line 1899: FROM ZX_SCO_TAXES_B_V -- Bug#5395227

1895: CURSOR currency_csr IS
1896: SELECT DISTINCT tax, -- Bug#5395227
1897: tax_currency_code,
1898: exchange_rate_type
1899: FROM ZX_SCO_TAXES_B_V -- Bug#5395227
1900: WHERE tax_regime_code = p_tax_regime_code;
1901:
1902: --Currencies can be passed at either the header level/line level
1903: CURSOR document_currency_csr IS

Line 2207: FROM ZX_SCO_TAXES_B_V

2203: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_id(ptnr_tax_line_index),
2204: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_type_code(ptnr_tax_line_index),
2205: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_currency_conversion_type(ptnr_tax_line_index)
2206: -- FROM ZX_SCO_TAXES -- Bug#5395227
2207: FROM ZX_SCO_TAXES_B_V
2208: WHERE tax_regime_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(ptnr_tax_line_index)
2209: AND tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2210: AND rownum = 1
2211: ORDER BY subscription_level_code; -- Bug#5395227