Untitled

exec sp_executesql N'[mrms].[lcr_Equation_SetaraKas_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N''
go
exec sp_executesql N'[mrms].[lcr_Equation_PlacementBI_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N''
go
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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 > case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 > case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 > case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 <= case when inputLPS = ''IDR'' then 2.25 else 4.25 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] * 10 > case when inputLPS = ''IDR'' then 2.25 else 4.25 end )'
go
exec sp_executesql N'[mrms].[lcr_Equation_NonOperasional_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N''
go
exec sp_executesql N'[mrms].[lcr_Equation_Komitmen_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N''
go
exec sp_executesql N'[mrms].[lcr_Equation_TradeFinance_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N''
go
exec sp_executesql N'[mrms].[lcr_Equation_TCPP_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N''
go
exec sp_executesql N'[mrms].[lcr_Equation_TCPPUMKM_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[POKOK_AWAL] >= 500000000 AND [EDW.LOAN].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') )'
go
exec sp_executesql N'[mrms].[lcr_Equation_TCPBI_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[DIVISI_CD] in (''CB1G'',''CB2G'',''CB3G'',''CMG'') )'
go
exec sp_executesql N'[mrms].[lcr_Equation_TCPK_Daily] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230529',@p1=N'([EDW.LOAN].[POKOK_AWAL] > 500000000 AND [EDW.LOAN].[DIVISI_CD] in (''CB1G'',''CB2G'',''CB3G'',''BBG'') )'
go