SELECT ASSET_CODE,AMORT_AMT,AMORT_MONTH,AMORT_STATUS FROM dbo.ASS_MASTER EXEC [ASS_AMORT_Do] '25/11/2022','hannh1','hannh1','ALL',NULL EXEC ASS_AMORT_Start @p_AMORT_ID ='' AMORT SELECT COUNT (*) FROM ASS_ENTRIES_POST WHERE TRN_ID ='' AND ISNULL(REF_NO,'') <> ''