Shulou(Shulou.com)06/01 Report--

create or replace function GET_ZNJ(

JFJZRQ in date,

YJE in number,

ZNJBL in number,

ZT in varchar2,

SJJFRQ in date,

MIAN_ZNJ in varchar2,

ZNJ_JMCS in number

) return NUMBER is

V_ZNJ NUMBER(14,2);

V_DATE date;

V_DAYS number;

begin

V_ZNJ := 0;

IF ZT = '5' THEN

V_DATE := SJJFRQ;

END IF;

V_DAYS := trunc(V_DATE) - trunc(JFJZRQ);

IF MIAN_ZNJ = '1' THEN --No relief 1

BEGIN

V_ZNJ := CASE WHEN V_DAYS

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.