495: Exception
496: When no_data_found then
497: select decode(pa_resource_utils.chk_supplier_in_use(p_vendor_id),'Y','N','Y')
498: into l_allow_merge_flg 499: from dual; 500: Return l_allow_merge_flg;
501: END Allow_Supplier_Merge;
502:
503: /***************************************************************************