APPS.IEM_EMAILACCOUNT_PUB dependencies on IEM_AGENTS

Line 148: FROM IEM_AGENTS A,

144: SELECT nvl(nvl(b.reply_to_address,b.return_address),b.email_address) reply_to_address,
145: a.signature,
146: a.agent_id,
147: a.email_account_id
148: FROM IEM_AGENTS A,
149: IEM_MSTEMAIL_ACCOUNTS B
150: WHERE (A.resource_id=p_RESOURCE_ID)
151: AND (A.email_account_id=B.EMAIL_ACCOUNT_ID)
152: ORDER BY a.agent_id;

Line 264: FROM IEM_AGENTS A,

260: SELECT nvl(nvl(b.reply_to_address,b.return_address),b.email_address) reply_to_address,
261: a.signature,
262: a.agent_id,
263: a.email_account_id
264: FROM IEM_AGENTS A,
265: IEM_MSTEMAIL_ACCOUNTS B
266: WHERE (A.resource_id=p_RESOURCE_ID)
267: AND (A.email_account_id=B.EMAIL_ACCOUNT_ID)
268: AND A.cherry_pick_flag = 'Y'

Line 462: from iem_agents agnt, fnd_responsibility resp,fnd_user_resp_groups respgrp,

458: END IF;
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