APPS.IEM_INBE_PVT SQL Statements

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

Line: 20

    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: 38

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