DBA Data[Home] [Help]

APPS.IEM_EMAILACCOUNT_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 185: FROM JTF_RS_RESOURCE_EXTNS

181: FOR agent_account_rec in agent_accounts_csr
182: LOOP
183: SELECT USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
184: INTO l_user_name, l_res_name
185: FROM JTF_RS_RESOURCE_EXTNS
186: WHERE RESOURCE_ID = p_resource_id;
187: select sender_flag into l_flag from iem_mstemail_accounts
188: where email_account_id= agent_account_rec.email_account_id;
189: IF l_flag=0 then -- From Name selected from Account.

Line 345: jtf_rs_resource_extns res, fnd_user fu,fnd_responsibility_tl resptl

341:
342: l_string := 'select agnt.resource_id, concat(concat(res.source_last_name, '', ''), res.source_first_name) as resource_name, res.user_name,
343: resptl.responsibility_name
344: from iem_agents agnt, fnd_responsibility resp,fnd_user_resp_groups respgrp,
345: jtf_rs_resource_extns res, fnd_user fu,fnd_responsibility_tl resptl
346: where agnt.resource_id=res.resource_id and res.user_id=respgrp.user_id
347: and resp.application_id=680
348: and resp.responsibility_id=respgrp.responsibility_id
349: and respgrp.user_id=fu.user_id