APPS.IEM_ACQ_PVT SQL Statements

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

Line: 21

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

Line: 39

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