Plz see this error very urgent
556433Jan 16 2007 — edited Jan 17 2007REP-1401: 'p_cad_sys_dtformula': Fatal PL/SQL error occurred.
ORA-01403: no data found
I wrote these lines in formula there is no complied error but when I run the report shows above error.
Please help why?
function P_CAD_SYS_DTFormula return Number is
CAD_RATE NUMBER;
CT NUMBER;
begin
SELECT COUNT(*) INTO CT FROM gl_daily_rates_V
WHERE TO_CHAR(CONVERSION_DATE,'DD/MM/RR')=TO_CHAR(SYSDATE,'DD/MM/RR')
AND USER_CONVERSION_TYPE='Corporate';
IF CT =1 THEN
SELECT SHOW_CONVERSION_RATE INTO CAD_RATE
FROM gl_daily_rates_V
WHERE TO_CHAR(CONVERSION_DATE,'DD/MM/RR')=TO_CHAR(SYSDATE,'DD/MM/RR')
AND USER_CONVERSION_TYPE='Corporate';
ELSE
SELECT SHOW_CONVERSION_RATE INTO CAD_RATE
FROM gl_daily_rates_V
WHERE TO_CHAR(CONVERSION_DATE,'DD/MM/RR')=TO_CHAR(SYSDATE,'DD/MM/RR')
AND USER_CONVERSION_TYPE='Corporate'
AND FROM_CURRENCY='CAD' AND TO_CURRENCY='USD';
END IF;
RETURN(CAD_RATE);
end;