apa.txt

sdhsadjsaljd sakjd sd lkJA`

select case (select 1 from survrate where ((select sum(amnt) from lspol where  contno = '?contno?' and polno = '?mainpolno?' and riskcode not in ('daca11', 'daca12', 'dacb11','dacb12', 'dacc11', 'dacc12')) is not null)) when 1 then (select count(1) from survrate where (select nvl(sum(amnt), 0) from lspol where contno = '?ContNo?' and polno = '?polno?' and riskcode in ('cebb11')) <= ((select sum(amnt) from lspol where contno = '?ContNo?' and polno = '?mainpolno?' and riskcode not in ('daca11', 'daca12', 'dacb11','dacb12', 'dacc11', 'dacc12')) * 3)) else 1 end from survrate





select case when exists(select 'X' from lspol where contno = '?contno?' and polno = mainpolno and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRC000') when 1 then ( select case ( select 1 from survrate  where (select sum(amnt) from lspol where contno = '?contno?'    and polno = mainpolno  and riskcode not in ('DACA11','DACA12','DACB11','DACB12','DACC11','DACC12','CEC11')  and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate



select case when exists(select 'X' from lspol where contno = '?contno?' and polno = mainpolno and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRC000') when 1 then ( select case ( select 1 from survrate  where (((select sum(amnt) from lspol where contno = '?ContNo?' and polno = '?mainpolno?' and riskcode not in ('daca11', 'daca12', 'dacb11','dacb12', 'dacc11', 'dacc12')) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate


select case when exists(select 'X' from lspol where contno = '?contno?' and polno = '?mainpolno?' and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') ) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRC000') when 1 then ( select case ( select 1 from survrate  where (select sum(amnt) from lspol where contno = '?contno?' and polno = '?mainpolno?'  and riskcode not in ('DACA11','DACA12','DACB11','DACB12','DACC11','DACC12','CEC11') ) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate

select case when exists(select 'X' from lspol where contno = '?contno?' and polno = mainpolno and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRC000') when 1 then ( select case ( select 1 from survrate  where (select sum(amnt) from lspol where contno = '?contno?'    and polno = mainpolno  and riskcode not in ('DACA11','DACA12','DACB11','DACB12','DACC11','DACC12','CEC11')  and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate

select case when exists(select 'X' from lspol where contno = '?contno?' and polno = mainpolno and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') and exists(select 'X' from lmriskapp where riskcode=lspol.riskcode)) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRD000') when 1 then ( select case ( select 1 from survrate  where (select sum(amnt) from lspol where contno = '?contno?' and polno = mainpolno  and riskcode not in ('DACA11','DACA12','DACB11','DACB12','DACC11','DACC12','CEC11')  and exists(select 'X' from lmriskapp where  riskcode=lspol.riskcode)) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate


select case when exists(select 'X' from lspol where contno = '?contno?' and polno = mainpolno and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRD000') when 1 then ( select case ( select 1 from survrate  where (select sum(amnt) from lspol where contno = '?contno?' and polno = mainpolno  and riskcode not in ('DACA11','DACA12','DACB11','DACB12','DACC11','DACC12','CEC11')  and exists(select 'X' from lmriskapp where risktype='L' and riskcode=lspol.riskcode)) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate


select case when exists(select 'X' from lspol where contno = '?contno?' and polno = mainpolno and riskcode not in ('DACA11', 'DACA12', 'DACB11', 'DACB12','DACC11', 'DACC12','CEC11') and exists(select 'X' from lmriskapp where riskcode=lspol.riskcode)) then (case ( select count(*) from lsduty where polno = '?PolNo?' and ContNo = '?ContNo?' and dutycode='HRD000') when 1 then ( select case ( select 1 from survrate  where (select sum(amnt) from lspol where contno = '?contno?' and polno = mainpolno  and riskcode not in ('DACA11','DACA12','DACB11','DACB12','DACC11','DACC12','CEC11')  and exists(select 'X' from lmriskapp where  riskcode=lspol.riskcode)) >= 20000) when 1 then 1 else 0 end from survrate ) else 1 end) else 1 end from survrate