DBA Data[Home] [Help]

APPS.ZX_TRL_ALLOCATIONS_PKG dependencies on ZX_SCO_TAXES

Line 706: FROM ZX_SCO_TAXES

702: 'line amt : ' || to_char(v_line_amt)) ;
703: END IF;
704: select tax_id
705: INTO l_tax_id
706: FROM ZX_SCO_TAXES
707: WHERE TAX_REGIME_CODE = p_tax_regime_code
708: AND TAX=p_tax;
709:
710: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1242: FROM ZX_SCO_TAXES

1238: select tax_id, tax_currency_code, tax_type_code,
1239: DECODE(NVL(l_tax_reporting_flag,'N'),'Y',
1240: legal_reporting_status_def_val,NULL)
1241: INTO l_tax_id, l_tax_currency_code, l_tax_type_code, l_legal_reporting_status
1242: FROM ZX_SCO_TAXES
1243: WHERE TAX_REGIME_CODE = p_tax_regime_code
1244: AND TAX=p_tax;
1245:
1246: EXCEPTION