Syntax error for Function

[Sachin Srivastava <ssr.teleatlas@xxxxxxxxx>]

I am unable to find out the syntax error in below code, please suggest?

ERROR:  syntax error at or near "select"
LINE 44:             select Count(0) into sFound  from budget_period ...
                     ^
********** Error **********

ERROR: syntax error at or near "select"
SQL state: 42601
Character: 1190

Code as below:

-------------------------

select Count(0) into sFound  from budget_period t where t.subscriber_id =subID
            and t.period_number = period and t.language_id=langCursor.Language_Id;
            if(sFound = 0)then         
                insert into budget_period (subscriber_id, company_id, period_number, period_name,
                period_length_code, first_day, last_day,creation_date, creation_user, update_date, update_user, language_id)
                values(subID, compID, period,  curMonth,  'MONTH',     
                firstDate, lastDate, LOCALTIMESTAMP, 'Admin',LOCALTIMESTAMP, 'Admin', langCursor.Language_Id);
            end if;

------------------------