Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
CURSOR get_sig IS SELECT signer_name FROM ia, ib, ic, is WHERE ia.itl_id = ib.itl_id AND ia.itl_ac_rting_id = ic.itl_ac_rting_id AND ia.itl_ac_rting_step_id = ic.itl_ac_rting_step_id AND ic.itl_sig_id = is.itl_sig_id AND ic.t_step = 'Y' AND ic.status <> 'DISAPPROVED' AND ib.itl_id = p_accred_id; BEGIN FOR final_sig_rec IN get_final_acc_signature LOOP cnt := cnt + 1; if cnt > 1 then vsig := vsig || ' / ' || final_sig_rec.signer_name; else vsig := final_sig_rec.signer_name; end if; END LOOP; return vsig; Exception When Others then RETURN '';
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.