DBA Data[Home] [Help]

APPS.JTF_IH_TOOLS dependencies on JTF_IH_OUTCOME_RESULTS

Line 305: -- This script checks and populates data from JTF_IH_OUTCOME_RESULTS table to

301: -- -------------------------------------------------------------------------
302: -- PROCEDURE: MIGRATE_WRAPUPS
303: --
304: -- DESCRIPTION:
305: -- This script checks and populates data from JTF_IH_OUTCOME_RESULTS table to
306: -- JTF_IH_WRAP_UPS (if same records weren't found there).
307: --
308: -- HISTORY:
309: -- 03/14/03 ialeshin - Created sql script

Line 388: from jtf_ih_outcome_results outres, jtf_ih_results_b res

384: -- get all the valid Outcome-Result pairs where the exists
385: -- in jtf_ih_results_b and is active for the outcome.
386: -- loop through the results to create more wrap-ups for this id
387: for curOutRes in (select outres.result_id, res.result_required
388: from jtf_ih_outcome_results outres, jtf_ih_results_b res
389: where outres.outcome_id = curOut.outcome_id and
390: outres.result_id = res.result_id and
391: (res.active <> 'N' or res.active is null)) loop
392:

Line 477: from jtf_ih_outcome_results outr, jtf_ih_results_b res

473: -- get all the valid Outcome-Result pairs where the exists
474: -- in jtf_ih_results_b and is active for the outcome.
475: -- loop through the results to create more wrap-ups for this id
476: for curOutRes in (select outr.result_id, res.result_required
477: from jtf_ih_outcome_results outr, jtf_ih_results_b res
478: where outr.outcome_id = curOut.outcome_id and
479: outr.result_id = res.result_id and
480: (res.active <> 'N' or res.active is null)) loop
481: