APPS.AST_UWQ_MLIST_ENUMS_PVT SQL Statements

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

Line: 23

    SELECT distinct schedule_id, schedule_name, list_source_type
    FROM
      ast_mlist1_uwq_v
    WHERE
      resource_id = pResourceID
    ORDER BY 1;

Line: 31

    SELECT schedule_id, schedule_name, list_source_type
    FROM
      ast_mlist1_all_uwq_v
    ORDER BY 1;

Line: 44

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

Line: 107

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

Line: 185

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