DBA Data[Home] [Help]

APPS.JTF_IH_TOOLS dependencies on JTF_IH_RESULT_REASONS

Line 411: from jtf_ih_result_reasons rr, jtf_ih_reasons_b rea

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:

Line 499: for curResRea in (select rr.reason_id from jtf_ih_result_reasons rr,

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