[Home] [Help]
493: END IF;
494: BEGIN
495: SELECT 1
496: INTO l_reason_cnt
497: FROM cm_reas_cds
498: WHERE
499: reason_code = p_adjustment_rec.reason_code
500: AND delete_mark = 0
501: AND ROWNUM = 1;