APPS.IEM_INBE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

    select a.from_name, a.email_account_id, c.resource_id
    from iem_mstemail_accounts a,iem_agents c
    where   a.email_account_id=c.email_account_id
    and c.resource_id=p_resource_id
    group by a.from_name,a.email_account_id,c.resource_id
    order by 1;

Line: 40

   Select meaning into l_node_label
   from fnd_lookups
   where lookup_type = 'IEM_UWQ_EMAIL_LABELS'
   and lookup_code = 'IEM_INBOUND_EMAIL_LBL';

Line: 74

       select acc.cherry_pick_flag ,agents.cherry_pick_flag
       into  p_acct_flag,p_user_flag
       from iem_mstemail_accounts acc, iem_agents agents
       where acc.email_account_id=cur_rec.email_account_id
       and agents.resource_id =p_resource_id
       and acc.email_account_id = agents.email_account_id;