select @ledgerid := objid from rptledger where tdno = 'tdno-here';

delete from rptledger_item where parentid = @ledgerid;
delete from rptledgerfaas where rptledgerid = @ledgerid;
delete from rptledger where objid = @ledgerid;