APPS.ZX_TRL_ALLOCATIONS_PKG dependencies on ZX_SCO_TAXES

Line 814: -- ZX_SCO_TAXES_B_V in place of ZX_SCO_TAXES

810: l_key VARCHAR2(100);
811: l_insert BOOLEAN ;
812:
813: -- Added this cursor to fetch the data from
814: -- ZX_SCO_TAXES_B_V in place of ZX_SCO_TAXES
815: CURSOR get_tax_id (c_tax_regime_code VARCHAR2,
816: c_tax VARCHAR2)
817: IS
818: SELECT tax_id,Def_Place_Of_Supply_Type_Code --Bug 12688194

Line 819: FROM zx_sco_taxes_b_v

815: CURSOR get_tax_id (c_tax_regime_code VARCHAR2,
816: c_tax VARCHAR2)
817: IS
818: SELECT tax_id,Def_Place_Of_Supply_Type_Code --Bug 12688194
819: FROM zx_sco_taxes_b_v
820: WHERE tax = c_tax
821: AND tax_regime_code = c_tax_regime_code
822: ORDER BY subscription_level_code;
823:

Line 1612: FROM ZX_SCO_TAXES

1608: select tax_id, tax_currency_code, tax_type_code,
1609: DECODE(NVL(l_tax_reporting_flag,'N'),'Y',
1610: legal_reporting_status_def_val,NULL)
1611: INTO l_tax_id, l_tax_currency_code, l_tax_type_code, l_legal_reporting_status
1612: FROM ZX_SCO_TAXES
1613: WHERE TAX_REGIME_CODE = p_tax_regime_code
1614: AND TAX=p_tax;
1615:
1616: EXCEPTION