APPS.IEX_STRATEGY_DIAG_REPORT dependencies on IEX_STRATEGY_TEMPLATES_TL

Line 311: iex_strategy_templates_tl tpl,

307: stry_temp_wkitem.name,
308: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',swi.status_code) STATUS_MEANING,
309: jtf.source_name
310: from iex_strategies sty,
311: iex_strategy_templates_tl tpl,
312: iex_strategy_work_items swi,
313: iex_stry_temp_work_items_vl stry_temp_wkitem,
314: jtf_rs_resource_extns jtf
315: where sty.strategy_id = p_strategy_id

Line 334: iex_strategy_templates_tl tpl

330: sty.score_value,
331: tpl.strategy_name,
332: TO_CHAR(sty.creation_date,'YYYY-MM-DD') creation_date
333: from iex_strategies sty,
334: iex_strategy_templates_tl tpl
335: where sty.strategy_id = p_strategy_id
336: and sty.strategy_template_id = tpl.strategy_temp_id
337: and tpl.language = userenv('LANG');
338:

Line 343: from iex_strategy_templates_tl tpl

339: cursor c_strategy_name (l_sty_template_id number)
340: is
341: select
342: tpl.strategy_name
343: from iex_strategy_templates_tl tpl
344: where tpl.strategy_temp_id = l_sty_template_id
345: and tpl.language = userenv('LANG');
346:
347: cursor c_first_work_item (l_sty_template_id number)