DBA Data[Home] [Help]

APPS.ZX_TRL_ALLOCATIONS_PKG dependencies on ZX_SCO_TAXES_B_V

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: