Select add_item.stk_code,description, qty,unt_PRC, ad_level2,op_typ,cust_no,history. Stk_code into
 :itrn_bar.item_code,
:itrn_bar.item_name,
:itrn_bar.qty,
Aa,
Bb,
Cc,
Dd,ff from add_item,clnt_option,history where add_item.STK_code=:control.a and
History. STK_code=:add_item.stk_code and
Clnt_option.cust_no=:imaster_bar.p_code;
If cc='level' then 
    :itrn_bar=:bb;
Else
:itrn_bar=:aa;
End if;

scenario is something like this i have added two codes in add_item table 

1001----containing both prices (a).Regular price (b).level 2 price
1002----containing only regular price

and added twi clients in client table .

c013----which has radio button selected "level2" price.
c014----regular price.


problem is when i am entering "1001" which has both prices working 100% fine with both clients c013,c014
but when i am entering code "1002" which has only regular price and client table radio button selected "regular price"

working with only code "c014" when i entered "c013" bringing blank data code as follo below.

 declare 
	aa varchar2(20);
	bb number(8);
	cc number(10);
	dd varchar2(8);
	ee varchar2(15);
	ff varchar2(20);

	begin

select stk_code,
       ad_level2,
       unt_prc
               into aa,
                    bb,
                    cc
      from add_item 
                  where
            add_item.stk_code=:block3.stk  ; 
             message(cc);
             message(cc);
             select op_typ,cust_no into dd,ee
from clnt_option
      where
              cust_no=:block3.clnt; 
       
       if dd='level2' then 
       
              :block3.prc:=bb;    
          else
              :block3.prc:=cc;    
     
      end if;
    	end;