APPS.IEX_PROFILE dependencies on JTF_IH_RESULTS_TL

Line 255: JTF_IH_RESULTS_TL JIRV

251: JIRV.short_description result
252: FROM JTF_IH_INTERACTIONS JII,
253: JTF_RS_RESOURCE_EXTNS_TL JRREV,
254: JTF_IH_OUTCOMES_TL JIOV,
255: JTF_IH_RESULTS_TL JIRV
256: WHERE JII.resource_id = JRREV.resource_id
257: AND JRREV.LANGUAGE (+)= USERENV('LANG')
258: AND JIOV.Outcome_id = JII.outcome_id
259: AND JIOV.LANGUAGE (+)= USERENV('LANG')

Line 317: JTF_IH_RESULTS_tl JIRV ,

313: FROM JTF_IH_INTERACTIONS JII ,
314: jtf_rs_resource_extns JRRES,
315: JTF_IH_OUTCOMES_tl JIOVT ,
316: jtf_ih_outcomes_b jiovb ,
317: JTF_IH_RESULTS_tl JIRV ,
318: JTF_IH_ACTIVITIES JIA
319: WHERE JII.resource_id = JRRES.resource_id
320: AND jii.interaction_id = jia.interaction_id
321: AND jiovt.outcome_id = jiovb.outcome_id

Line 352: -- JTF_IH_RESULTS_TL JIRV,

348: -- JTF_IH_OUTCOMES_VL JIOV,
349: --START BUG 4930386 jsanju 01/10/06
350: --JTF_IH_RESULTS_VL JIRV,
351: -- JTF_IH_RESULTS_B JIRB,
352: -- JTF_IH_RESULTS_TL JIRV,
353: --END BUG 4930386 jsanju 01/10/06
354: -- JTF_IH_ACTIVITIES_VL JIA
355: -- WHERE JII.resource_id = JRREV.resource_id
356: -- AND jii.interaction_id = jia.interaction_id

Line 381: JTF_IH_RESULTS_TL JIRV,

377: FROM JTF_IH_INTERACTIONS JII,
378: JTF_RS_RESOURCE_EXTNS_TL JRREV,
379: JTF_IH_OUTCOMES_TL JIOV,
380: JTF_IH_RESULTS_B JIRB,
381: JTF_IH_RESULTS_TL JIRV,
382: JTF_IH_ACTIVITIES JIA
383: WHERE JII.resource_id = JRREV.resource_id
384: AND JRREV.LANGUAGE (+)= USERENV('LANG')
385: AND jii.interaction_id = jia.interaction_id

Line 436: JTF_IH_RESULTS_TL JIRV

432: JIRV.short_description result
433: FROM JTF_IH_INTERACTIONS JII,
434: JTF_RS_RESOURCE_EXTNS_TL JRREV,
435: JTF_IH_OUTCOMES_TL JIOV,
436: JTF_IH_RESULTS_TL JIRV
437: WHERE JII.resource_id = JRREV.resource_id
438: AND JRREV.LANGUAGE (+)= USERENV('LANG')
439: AND JIOV.Outcome_id = JII.outcome_id
440: AND JIOV.LANGUAGE (+)= USERENV('LANG')