APPS.JTF_AK_QUERY SQL Statements

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

Line: 56

    select flow_code into   l_flow_code
    from   ak_flows_vl
    where  flow_application_id = p_appl_id
    and    name = p_flow_name;*/

Line: 63

SELECT fpr.page_application_id, fpr.page_code,
       fpr.region_application_id, fpr.region_code,
       fpr.database_object_name
  INTO l_page_application_id, l_page_code,
       l_parent_region_appl_id, l_parent_region_code,
       l_database_object_name
  FROM ak_flow_pages_vl fp,
       ak_flow_page_regions_v fpr
 WHERE fp.flow_application_id = p_appl_id
   AND fp.flow_application_id = fpr.flow_application_id
   AND fp.flow_code = l_flow_code
   AND fp.flow_code = fpr.flow_code
   AND fp.page_application_id = p_appl_id
   AND fp.page_application_id = fpr.page_application_id
   AND fp.page_code = p_parent_page_name
   AND fp.page_code = fpr.page_code
   AND fp.primary_region_code = fpr.region_code
   AND fp.primary_region_appl_id = fpr.region_application_id;

Line: 84

    select 1 into l_pk_exists
    from   ak_unique_keys
    where  database_object_name = l_database_object_name
    and    unique_key_name = p_primary_key_name;