APPS.AST_UWQ_PLISTS_CONTS_ENUMS_PVT SQL Statements

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

Line: 25

  SELECT
  alh.list_name,
  alh.list_header_id,
  alh.list_source_type
  from ams_list_headers_vl alh
  where
  owner_user_id = c_resource_id
  and list_type='MANUAL' and
  list_source_type in ('CONTACT', 'CONSUMER')
  and enabled_flag = 'Y' and
  list_source='UWQ'
  order by creation_date desc;

Line: 51

     		Select meaning into l_node_label
          		from ast_lookups
          		where lookup_type = lkp_type
                and lookup_code = lkp_code;

Line: 121

		 ' and EXISTS (SELECT /*+ no_unnest */ 1 ' ||
            			' FROM AS_ACCESSES_ALL ASS ' ||
            			' WHERE ASS.SALESFORCE_ID = :resource_id ' ||
				        ' AND CUSTOMER_ID = ASS.CUSTOMER_ID) ';