Lỗi bảo lãnh, gỡ bảo lãnh
select * from INTELLECT.OT_GR_DETAILS_LATEST WHERE LETTER_GUAR_NO ='LCA091221APLL578'
select * from INTELLECT.OT_GR_SUB_FLDR_ATTR WHERE REF_NO ='E111090034321230653'
select * from INTELLECT.OT_GR_TXN_DETAILS WHERE REF_NO ='E111090034321230653'
DECLARE
VLINENO VARCHAR2(200);
VLOANNO VARCHAR2(200);
VFLAG VARCHAR2(200);
VERRORCODE NUMBER;
VERRORDESC VARCHAR2(200);
BEGIN
VLINENO := NULL;
--VLOANNO := '1507464'; Giá tr? mpifkey trong b?ng kho?n vay m_proj_info
VFLAG := NULL;
VERRORCODE := NULL;
VERRORDESC := NULL;
INTELLECT.SPCOLLDELINK ( VLINENO, 'E111090034321230653', VFLAG, VERRORCODE, VERRORDESC );
END;


