DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_SCO_TAXES

Line 891: from zx_sco_taxes zx, -- Changed from clause to use sco views not base tables

887:
888:
889: BEGIN
890: select tax_type_code INTO l_tax_type -- from zx_taxes_b zx, zx_rates_b zr
891: from zx_sco_taxes zx, -- Changed from clause to use sco views not base tables
892: zx_sco_rates zr
893: where zx.tax = zr.tax
894: AND zx.tax_regime_code = zr.tax_regime_code
895: AND zr.tax_rate_code = l_tax_code

Line 4345: from zx_sco_taxes zx, -- Changed from clause to use sco views not base tables

4341: and trx_level_type = SYNC_TAX_LINES.trx_level_type(1);
4342:
4343: BEGIN
4344: select tax_type_code INTO l_tax_type -- from zx_taxes_b zx, zx_rates_b zr
4345: from zx_sco_taxes zx, -- Changed from clause to use sco views not base tables
4346: zx_sco_rates zr
4347: where zx.tax = zr.tax
4348: AND zr.tax_rate_code = l_tax_code
4349: AND rownum = 1;

Line 4742: from zx_sco_taxes zx, -- Changed from clause to use sco views not base tables

4738: and trx_level_type = l_trx_level_type;
4739:
4740: BEGIN
4741: select tax_type_code INTO l_tax_type -- from zx_taxes_b zx, zx_rates_b zr
4742: from zx_sco_taxes zx, -- Changed from clause to use sco views not base tables
4743: zx_sco_rates zr
4744: where zx.tax = zr.tax
4745: AND zr.tax_rate_code = l_tax_code
4746: AND rownum = 1;