ACS3 Data Model

     1: function im_cust_status_from_id ( v_status_id IN integer )
     2: return varchar
     3: IS
     4:   v_status    im_customer_status.customer_status%TYPE;
     5: BEGIN
     6:   select customer_status into v_status from im_customer_status where customer_status_id = v_status_id;
     7:   return v_status;
     8: END;