Calculation of late fee for oracle
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
