* PHONE NUMBER *
Begin
 
if :P9_CREATE_SW = 0 then


for c1 in  (

  Select  CUSTOMER_ID, PHONE_NUMBER1  from DEMO_CUSTOMERS
)

loop

  if  c1.CUSTOMER_ID = :p9_CUSTOMER_ID then
      :p9_PHONE_NUMBER1   := c1.PHONE_NUMBER1; 
  end if;
end loop;

end if;

end;

I want to