SELECT *
          , FN_SY_CLASS_R01(type_cd,'CLASS_NM') type_cd_nm
FROM BD_BBS_CUSTOMER
WHERE ins_id = :login_id
AND bd_bbs_customer_seq = :bd_bbs_customer_seq