APPS.AK_DOWNLOAD_GRP SQL Statements

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

Line: 15

  select application_id
  from   fnd_application_vl
  where  application_short_name = short_name_param;

Line: 19

    select tbl_index
	from ak_loader_temp
	where tbl_index = 1
	and session_id = session_id_param;

Line: 24

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code;

Line: 32

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.responsibility_id = levelpk;

Line: 41

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.responsibility_id is not null;

Line: 50

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.org_id = levelpk;

Line: 59

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.org_id is not null;

Line: 68

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.function_name = levelpk;

Line: 77

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.function_name is not null;

Line: 86

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.localization_code = levelpk;

Line: 95

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.localization_code is not null;

Line: 104

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.site_id = levelpk;

Line: 113

   select ac.customization_application_id, ac.customization_code,
          ac.region_application_id, ac.region_code
   from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
   where  ac.region_application_id = appl_id_param
   and    ac.region_code like custom_code_param
   and    ac.region_application_id = ar.region_application_id
   and    ac.region_code = ar.region_code
   and    ac.site_id is not null;

Line: 122

    select organization_id
    from   MTL_PARAMETERS
    where  organization_code = levelpk;

Line: 126

    select responsibility_id
    from   FND_RESPONSIBILITY
    where  responsibility_key = levelpk;

Line: 130

    select instr(objectpk,'%')
    from dual;

Line: 133

   select region_application_id, region_code
   from ak_regions
   where region_application_id = appl_id_param
   and region_code like region_code_param;

Line: 138

   select flow_application_id, flow_code
   from ak_flows
   where flow_application_id = appl_id_param
   and flow_code like flow_code_param;

Line: 143

   select database_object_name
   from ak_objects
   where database_object_name like database_obj_param;

Line: 217

  select sid into l_session_id
  from v$session
  where AUDSID = userenv('SESSIONID');