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 302: FROM JTF_RS_RESOURCE_EXTNS

298: FOR agent_account_rec in agent_accounts_csr
299: LOOP
300: SELECT USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
301: INTO l_user_name, l_res_name
302: FROM JTF_RS_RESOURCE_EXTNS
303: WHERE RESOURCE_ID = p_resource_id;
304: select sender_flag into l_flag from iem_mstemail_accounts
305: where email_account_id= agent_account_rec.email_account_id;
306: IF l_flag=0 then -- From Name selected from Account.

Line 463: jtf_rs_resource_extns res, fnd_user fu,fnd_responsibility_tl resptl

459:
460: l_string := 'select agnt.resource_id, concat(concat(res.source_last_name, '', ''), res.source_first_name) as resource_name, res.user_name,
461: resptl.responsibility_name
462: from iem_agents agnt, fnd_responsibility resp,fnd_user_resp_groups respgrp,
463: jtf_rs_resource_extns res, fnd_user fu,fnd_responsibility_tl resptl
464: where agnt.resource_id=res.resource_id and res.user_id=respgrp.user_id
465: and resp.application_id=680
466: and resp.responsibility_id=respgrp.responsibility_id
467: and respgrp.user_id=fu.user_id