APPS.JTF_REGION_PUB SQL Statements

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

Line: 24

    cursor each_attribute_code is select attribute_code
      from ak_region_items
	where region_code = p_region_code and
	  region_application_id = p_application_id;

Line: 29

    cursor excluded_resps (p_attribute_code varchar2) is select
      responsibility_id from ak_excluded_items
      where resp_application_id = p_application_id and
	attribute_application_id = p_application_id and
	attribute_code = p_attribute_code;

Line: 54

      select responsibility_id from fnd_responsibility
        where application_id = pp_appid;

Line: 138

    select userenv('lang') into p_lang from dual;

Line: 144

      for rc in (select unique region_code from ak_regions_vl
	  where region_application_id = p_get_application_id) loop
	t_region_codes(t_region_code_index) := rc.region_code;

Line: 272

   select object_name,name,description,database_object_name
    into p_object_name, p_region_name,p_region_description,
	temp_database_object_name
    from ak_regions_vl
    where region_code = t_region_code and
	region_application_id = p_application_id;

Line: 279

   for c1 in (select attribute_label_long,attribute_label_short,data_type,
		attribute_name , object_attribute_flag,  attribute_code,
		attribute_description, display_value_length,lov_region_code,
		node_display_flag,node_query_flag

		from ak_region_items_vl a
		where region_code=t_region_code and
		      region_application_id = p_application_id and
		      attribute_code not in
			(select attribute_code from ak_excluded_items where
				 responsibility_id=p_responsibility_id and
			         resp_application_id=p_application_id  and
                                 attribute_application_id= p_application_id and
				 attribute_code = a.attribute_code)
		order by display_sequence)
    LOOP
      cnt := cnt + 1;

Line: 300

         select column_name into p_column_name from ak_object_attributes
	   where attribute_code = c1.attribute_code;

Line: 303

         select column_name into p_column_name from ak_object_attributes
	   where attribute_code = c1.attribute_code and
	   database_object_name = temp_database_object_name;

Line: 335

  select attribute_label_long into l_attribute_label_long
    from ak_region_items_vl a
    where region_code=p_region_code and attribute_code = p_attribute_code;

Line: 518

    select column_name into p_column_name from ak_object_attributes
      where attribute_code = ak_query_pkg.g_items_table(i).attribute_code;