/*==================================
** first step 
FAAS UPDATE TO INTERIM*/
 
UPDATE faas_list SET state = 'INTERIM' WHERE TDNO = '2020-07-0020-00169';
UPDATE faas SET state = 'INTERIM' WHERE TDNO = '2020-07-0020-00169';

/*==================================
** SECOND STEP
DELETE THE LATEST ARP NO. "DOUBLE LEDGER"

/*===========================================================
** IMPORTANT !!!!!
**    - use only if all payments are CAPTURED mode
===========================================================*/

select @ledgerid := objid from rptledger where tdno = '2020-07-0031-00137';

/*==================================
** THIRD STEP
*/


delete from report_rptdelinquency_item where rptledgerid = 'F7f88bb53:1759078668d:-451b'
;

delete from rptbill_ledger where rptledgerid = 'F7f88bb53:1759078668d:-451b'
;

delete from rptpayment_share where parentid in (
    select objid from rptpayment where refid = 'F7f88bb53:1759078668d:-451b'
)
;

delete from rptpayment_item where parentid in (
    select objid from rptpayment where refid = 'F7f88bb53:1759078668d:-451b'
)
;

delete from rptpayment where refid = 'F7f88bb53:1759078668d:-451b'
;

delete from rptledger_item where parentid = 'F7f88bb53:1759078668d:-451b'
;

delete from rptledgerfaas where rptledgerid = 'F7f88bb53:1759078668d:-451b'
;

delete from rptledger where objid = 'F7f88bb53:1759078668d:-451b'
;