APPS.HZ_ACT_UTIL_PUB SQL Statements

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

Line: 12

  select al.MEANING
  from hz_cust_acct_sites asite,
       hz_cust_site_uses asu,
       ar_lookups  al
  where asite.cust_acct_site_id = l_act_site_id
  and   asu.status = 'A'
  and   asu.cust_acct_site_id = asite.cust_acct_site_id
  and   al.lookup_type  = 'SITE_USE_CODE'
  and   al.lookup_code  =  asu.site_use_code
  order by primary_flag DESC;

Line: 62

  select al.MEANING
  from hz_cust_acct_sites asite,
       hz_cust_site_uses asu,
       ar_lookups  al
  where asite.cust_acct_site_id = l_act_site_id
  and   asu.cust_acct_site_id = asite.cust_acct_site_id
  and   al.lookup_type  = 'SITE_USE_CODE'
  and   al.lookup_code  =  asu.site_use_code
  order by primary_flag DESC, asu.status ASC ;

Line: 108

   select ps.location_id into l_location_id
   from hz_party_sites ps, hz_cust_acct_sites  asite
   where ps.party_site_id = asite.party_site_id
   and  asite.cust_acct_site_id = p_act_site_id;

Line: 132

  select al.MEANING
  from --hz_cust_account_roles roles,
       hz_role_responsibility role_type,
       ar_lookups  al
  where role_type.cust_account_role_id = l_cust_account_role_id
--  and   roles.cust_account_role_id = role_type.cust_account_role_id
  and   al.lookup_type = 'SITE_USE_CODE'
  and   al.lookup_code = role_type.responsibility_type
  order by role_type.primary_flag DESC;