407:
408: -- add all valid active reasons for the current outcome_id
409: -- and result_id that exist in the jtf_ih_reasons_b table
410: for curResRea in (select rr.reason_id
411: from jtf_ih_result_reasons rr, jtf_ih_reasons_b rea
412: where rr.result_id = curOutRes.result_id and
413: rr.reason_id = rea.reason_id and
414: ( rea.active <> 'N' or rea.active is null)) loop
415:
495: end if;
496:
497: -- add all valid active reasons for the current outcome_id and
498: -- result_id that exist in the jtf_ih_reasons_b table
499: for curResRea in (select rr.reason_id from jtf_ih_result_reasons rr,
500: jtf_ih_reasons_b rea
501: where rr.result_id = curOutRes.result_id and
502: rr.reason_id = rea.reason_id and
503: (rea.active <> 'N' or rea.active is null)) loop