APPS.IEX_STRATEGY_CNT_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 3276: from jtf_rs_resource_extns

3272:
3273: cursor c_resource_name (p_resource_id number)
3274: is
3275: select source_name
3276: from jtf_rs_resource_extns
3277: where resource_id = p_resource_id;
3278:
3279: begin
3280: writelog('Begin get_resource');

Line 3378: from jtf_rs_resource_extns

3374:
3375: cursor c_resource_name (p_resource_id number)
3376: is
3377: select source_name
3378: from jtf_rs_resource_extns
3379: where resource_id = p_resource_id;
3380:
3381: cursor c_sty_quest_items
3382: is

Line 3616: jtf_rs_resource_extns jtf

3612: from iex_strategies sty,
3613: iex_strategy_templates_tl tpl,
3614: iex_strategy_work_items swi,
3615: iex_stry_temp_work_items_vl stry_temp_wkitem,
3616: jtf_rs_resource_extns jtf
3617: where sty.strategy_id = p_strategy_id
3618: and sty.strategy_template_id = tpl.strategy_temp_id
3619: and tpl.language = userenv('LANG')
3620: and sty.next_work_item_id = swi.work_item_id

Line 4223: from jtf_rs_resource_extns

4219: begin
4220: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
4221: select SOURCE_NAME,USER_NAME
4222: into l_SourceName,l_UserName
4223: from jtf_rs_resource_extns
4224: where RESOURCE_ID=l_default_rs_id;
4225: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Resource Id :' || l_default_rs_id || ' Profile Name IEX: Strategy Assignment Default Resource (IEX_STRY_DEFAULT_RESOURCE) , Resource Name :' || l_SourceName || ' , User Name :' || l_UserName);
4226: EXCEPTION
4227: WHEN OTHERS THEN