MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table LLDUEDET (LOANNO varchar(10), DUEDT date, DUECD varchar(3), STARTDT date, ENDDT date, DUEAMT double, DUEPD double);
insert into LLDUEDET select '100', '2019-11-30', 'PRI', '2019-10-30', '2019-11-30', 19546.62, 0.0;
insert into LLDUEDET select '100', '2019-11-30', 'INT', '2019-10-30', '2019-11-30', 10808.38, 1062.86;
insert into LLDUEDET select '100', '2019-11-30', 'PEN', '2019-10-30', '2019-11-30', 1500.0, 1500.0;

insert into LLDUEDET select '100', '2019-12-30', 'PRI', '2019-11-30', '2019-12-30', 20158.62, 0.0;
insert into LLDUEDET select '100', '2019-12-30', 'INT', '2019-11-30', '2019-12-30', 11498.38, 3212.46;

insert into LLDUEDET select '100', '2020-03-01', 'CCF', '2020-03-01', '2020-03-01', 200.0, 0.0;
insert into LLDUEDET select '100', '2020-03-01', 'CFR', '2020-03-01', '2020-03-01', 729.17, 0.0;
select * from LLDUEDET;


LOANNO
DUEDT
DUECD
STARTDT
ENDDT
DUEAMT
DUEPD


100
2019-11-30
PRI
2019-10-30
2019-11-30
19546.62
0

100
2019-11-30
INT
2019-10-30
2019-11-30
10808.38
1062.86

100
2019-11-30
PEN
2019-10-30
2019-11-30
1500
1500

100
2019-12-30
PRI
2019-11-30
2019-12-30
20158.62
0

100
2019-12-30
INT
2019-11-30
2019-12-30
11498.38
3212.46

100
2020-03-01
CCF
2020-03-01
2020-03-01
200
0

100
2020-03-01
CFR
2020-03-01
2020-03-01
729.17
0


select pc.LOANNO, pc.DUEDT, pc.DUECD, pc.STARTDT, pc.ENDDT, pc.DUEAMT, coalesce(pa.DUEPD, 0.0) DUEPD
from (
  select LOANNO, DUEDT, 'PEN' DUECD, STARTDT, ENDDT, ((SUM(DUEAMT)-SUM(DUEPD)) * 30) * .1 DUEAMT
  from LLDUEDET
  WHERE DUEAMT != DUEPD
  and DUECD in ('PRI', 'INT')
  group by LOANNO, DUEDT, STARTDT, ENDDT
  having count(*) = 2
) pc
left join (
  select LOANNO, DUEDT, SUM(DUEPD) DUEPD
  from LLDUEDET
  where DUECD  = 'PEN'
  group by LOANNO, DUEDT
) pa on pa.loanno = pc.loanno and pa.duedt = pc.duedt


LOANNO
DUEDT
DUECD
STARTDT
ENDDT
DUEAMT
DUEPD


100
2019-11-30
PEN
2019-10-30
2019-11-30
87876.42
1500

100
2019-12-30
PEN
2019-11-30
2019-12-30
85333.62000000001
0


SELECT LOANNO, DUEDT, DUECD, STARTDT, ENDDT, DUEAMT, DUEPD
FROM LLDUEDET
WHERE DUEAMT != DUEPD
union all
select pc.LOANNO, pc.DUEDT, pc.DUECD, pc.STARTDT, pc.ENDDT, pc.DUEAMT, coalesce(pa.DUEPD, 0.0) DUEPD
from (
  select LOANNO, DUEDT, 'PEN' DUECD, STARTDT, ENDDT, ((SUM(DUEAMT)-SUM(DUEPD)) * 30) * .1 DUEAMT
  from LLDUEDET
  WHERE DUEAMT != DUEPD
  and DUECD in ('PRI', 'INT')
  group by LOANNO, DUEDT, STARTDT, ENDDT
  having count(*) = 2
) pc
left join (
  select LOANNO, DUEDT, SUM(DUEPD) DUEPD
  from LLDUEDET
  where DUECD  = 'PEN'
  group by LOANNO, DUEDT
) pa on pa.loanno = pc.loanno and pa.duedt = pc.duedt


LOANNO
DUEDT
DUECD
STARTDT
ENDDT
DUEAMT
DUEPD


100
2019-11-30
PRI
2019-10-30
2019-11-30
19546.62
0

100
2019-11-30
INT
2019-10-30
2019-11-30
10808.38
1062.86

100
2019-12-30
PRI
2019-11-30
2019-12-30
20158.62
0

100
2019-12-30
INT
2019-11-30
2019-12-30
11498.38
3212.46

100
2020-03-01
CCF
2020-03-01
2020-03-01
200
0

100
2020-03-01
CFR
2020-03-01
2020-03-01
729.17
0

100
2019-11-30
PEN
2019-10-30
2019-11-30
87876.42
1500

100
2019-12-30
PEN
2019-11-30
2019-12-30
85333.62000000001
0


select LOANNO, DUEDT, DUECD, STARTDT, ENDDT, DUEAMT, DUEPD
from
(
  SELECT LOANNO, DUEDT, DUECD, STARTDT, ENDDT, DUEAMT, DUEPD
         , case 
            when DUECD = 'PRI' then 1
            when DUECD = 'INT' then 2
            else 10
           end ord
  FROM LLDUEDET
  WHERE DUEAMT != DUEPD
   union all
  select pc.LOANNO, pc.DUEDT, pc.DUECD, pc.STARTDT, pc.ENDDT, pc.DUEAMT, coalesce(pa.DUEPD, 0.0) DUEPD
         ,3 ord
  from (
    select LOANNO, DUEDT, 'PEN' DUECD, STARTDT, ENDDT, ((SUM(DUEAMT)-SUM(DUEPD)) * 30) * .1 DUEAMT
    from LLDUEDET
    WHERE DUEAMT != DUEPD
    and DUECD in ('PRI', 'INT')
    group by LOANNO, DUEDT, STARTDT, ENDDT
    having count(*) = 2
  ) pc
  left join (
    select LOANNO, DUEDT, SUM(DUEPD) DUEPD
    from LLDUEDET
    where DUECD  = 'PEN'
    group by LOANNO, DUEDT
  ) pa on pa.loanno = pc.loanno and pa.duedt = pc.duedt
) s
order by LOANNO, DUEDT, ord


LOANNO
DUEDT
DUECD
STARTDT
ENDDT
DUEAMT
DUEPD


100
2019-11-30
PRI
2019-10-30
2019-11-30
19546.62
0

100
2019-11-30
INT
2019-10-30
2019-11-30
10808.38
1062.86

100
2019-11-30
PEN
2019-10-30
2019-11-30
87876.42
1500

100
2019-12-30
PRI
2019-11-30
2019-12-30
20158.62
0

100
2019-12-30
INT
2019-11-30
2019-12-30
11498.38
3212.46

100
2019-12-30
PEN
2019-11-30
2019-12-30
85333.62000000001
0

100
2020-03-01
CCF
2020-03-01
2020-03-01
200
0

100
2020-03-01
CFR
2020-03-01
2020-03-01
729.17
0
LOANNO	DUEDT	DUECD	STARTDT	ENDDT	DUEAMT	DUEPD
100	2019-11-30	PRI	2019-10-30	2019-11-30	19546.62	0
100	2019-11-30	INT	2019-10-30	2019-11-30	10808.38	1062.86
100	2019-11-30	PEN	2019-10-30	2019-11-30	1500	1500
100	2019-12-30	PRI	2019-11-30	2019-12-30	20158.62	0
100	2019-12-30	INT	2019-11-30	2019-12-30	11498.38	3212.46
100	2020-03-01	CCF	2020-03-01	2020-03-01	200	0
100	2020-03-01	CFR	2020-03-01	2020-03-01	729.17	0