DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_SCO_RATES

Line 892: zx_sco_rates zr

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
896: AND zx.live_for_processing_flag = 'Y' --Bug 7594634

Line 4346: zx_sco_rates zr

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;
4350: EXCEPTION

Line 4743: zx_sco_rates zr

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;
4747: EXCEPTION