DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on ZX_SCO_TAXES_B_V

Line 955: FROM ZX_SCO_TAXES_B_V

951: ELSE
952: BEGIN
953: SELECT NVL(TAX_EXMPT_SOURCE_TAX, TAX_ACCOUNT_SOURCE_TAX) --Bug 8724051
954: INTO l_tax_account_source_tax
955: FROM ZX_SCO_TAXES_B_V
956: WHERE tax_regime_code = p_tax_regime_code
957: AND tax = tax_identifier_tab(i)
958: AND ( g_trx_date >= effective_from AND (g_trx_date <= effective_to OR effective_to IS NULL));
959: EXCEPTION

Line 1098: FROM ZX_SCO_TAXES_B_V

1094: IF tax_identifier_tab(i) = 'DISTRICT' THEN
1095: BEGIN
1096: SELECT NVL(TAX_EXMPT_SOURCE_TAX, TAX_ACCOUNT_SOURCE_TAX) --Bug 8724051
1097: INTO l_tax_account_source_tax
1098: FROM ZX_SCO_TAXES_B_V
1099: WHERE tax_regime_code = p_tax_regime_code
1100: AND tax = tax_identifier_tab(i)
1101: AND ( g_trx_date >= effective_from AND (g_trx_date <= effective_to OR effective_to IS NULL));
1102: EXCEPTION