Untitled

exec sp_executesql N'[mrms].[lcr_Equation_NasabahPeroranganStabil_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'(LOG_SUM_END_SALDO_AKHIR_START[EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START <= 2000000000SUM_SUM_END_SALDO_AKHIR_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_NasabahPeroranganTidakStabil_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'(( LOG_SUM_END_SALDO_AKHIR_START [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START > 2000000000SUM_SUM_END_SALDO_AKHIR_END  ) OR [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 > case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end )'
go






exec sp_executesql N'[mrms].[lcr_Equation_NasabahUMKMStabil_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[SUM_POKOK_AWAL] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );(LOG_SUM_END_SALDO_AKHIR_START[EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START <= 2000000000SUM_SUM_END_SALDO_AKHIR_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_NasabahUMKMTidakStabil_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[SUM_POKOK_AWAL] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );(( LOG_SUM_END_SALDO_AKHIR_START [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START > 2000000000SUM_SUM_END_SALDO_AKHIR_END  ) OR [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 > case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end )'
go

exec sp_executesql N'[mrms].[lcr_Equation_KorporasiOp_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[SUM_POKOK_AWAL] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(LOG_SUM_END_SALDO_AKHIR_START[EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START <= 2000000000SUM_SUM_END_SALDO_AKHIR_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_KorporasiOp_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[SUM_POKOK_AWAL] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(( LOG_SUM_END_SALDO_AKHIR_START [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START >2000000000SUM_SUM_END_SALDO_AKHIR_END  ) OR [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 > case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end )'
go


exec sp_executesql N'[mrms].[lcr_Equation_KorporasiNonOp_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[SUM_POKOK_AWAL] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(LOG_SUM_END_SALDO_AKHIR_START[EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START <= 2000000000SUM_SUM_END_SALDO_AKHIR_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_KorporasiNonOp_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[SUM_POKOK_AWAL] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(( LOG_SUM_END_SALDO_AKHIR_START [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 <= case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end AND LOG_SUM_END_SALDO_AKHIR_END SUM_SUM_END_SALDO_AKHIR_START >2000000000SUM_SUM_END_SALDO_AKHIR_END  ) OR [EDW.DEPOSITS].[NISBAH_AKHIR] * 9.10/100 > case when inputLPS = ''IDR'' then 4.25/100 else 2.25/100 end )'
go