Hi
IF PLANSTATUS = 3 OR PLANSTATUS = 12 OR PLANSTATUS = 13 THEN
PLANPAYERSHARECV := 0;
ELSE
IF PLANSTATUS = 6 OR PLANSTATUS = 8 OR PLANSTATUS = 9 THEN
PLANPAYERSHARECV := PAYERSHARECV;
ELSE
IF USDCOST <> 0 THEN
PLANPAYERSHARECV := ROUND(USDCOST * GET_CONVERSIONRATE(1,POLICYCURRID,TRANSDATE),2);
ELSE
PLANPAYERSHARECV := PAYERSHARECV;
END IF;
END IF;
END IF;
Help me Out Guys
Regards,
Venkatesh Salla