APPS.HXC_LOV_MIGRATION SQL Statements

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

Line: 21

        SELECT application_id
          INTO l_appl_id
          FROM fnd_application
         WHERE application_short_name = P_APPLICATION_SHORT_NAME;

Line: 46

    SELECT *
      INTO l_region_row
      FROM ak_regions_vl
     WHERE region_code = p_region_code
       AND region_application_id = p_application_id;

Line: 91

  SELECT *
    FROM ak_region_items_vl
   WHERE region_code = p_ak_region_code
     AND region_application_id = p_ak_region_app_id
   ORDER BY display_sequence;

Line: 217

    SELECT region_code
      FROM  ak_regions
     WHERE region_application_id = 809
       AND region_style = 'LOV'
       AND region_code NOT IN
            ('HXCAPPROVALPEOPLELOV'
            ,'HXC_CUI_LOV_PROJECT'
            ,'HXC_CUI_LOV_TASK'
            ,'HXC_CUI_LOV_EXPTYPE'
            ,'HXC_CUI_LOV_SYSLINKFUNC'
            ,'HXC_CUI_PROJECT_LOV'
            ,'HXC_CUI_EXPTYPE_LOV'
            ,'HXC_CUI_TASK_LOV'
            ,'HXC_CUI_LOV_EXPTYPE_ELEMENT'
            ,'HXC_CUI_OVERRIDE_APPROVER_LOV'
            ,'HXC_CUI_PROJECT_B_LOV'
            ,'HXC_CUI_TASK_B_LOV');