APPS.HR_PARAMETER_HRMNPSUM SQL Statements

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

Line: 97

    select 'SIRO' lookup_code
    ,      meaning
    from   hr_lookups
    where  lookup_type = 'YES_NO'
    and    lookup_code = 'Y'
    UNION
    select 'SINR' lookup_code
    ,       meaning
    from   hr_lookups
    where  lookup_type = 'YES_NO'
    and    lookup_code = 'N'
    order by 1 desc;

Line: 115

  params(i).Value := htf.formSelectOpen( 'ORGPRC' );

Line: 118

                       htf.formSelectOption(ci_incl_subord.meaning,NULL,
                       'VALUE="'||ci_incl_subord.lookup_code||'"');

Line: 121

    params(i).Value := params(i).Value || htf.formSelectClose;

Line: 130

    select -1 plan_id, '    ' plan_name
      from sys.dual
     union
    select plan_id, description plan_name
      from bisbv_business_plans
     where current_plan_flag='Y'
     order by 2;

Line: 142

  params(i).Value := htf.formSelectOpen( 'BPL_ID' );

Line: 145

                       htf.formSelectOption(ci_bpl.plan_name,NULL,
                       'VALUE="'||ci_bpl.plan_id||'"');

Line: 148

  params(i).Value := params(i).Value || htf.formSelectClose;

Line: 157

    select '1' lev_code,
           message_text lev
    from fnd_new_messages
    where message_name = 'HR_BIS_AREA'
    and application_id = 800
    and language_code = userenv('LANG')
    union
    select '2' lev_code,
           message_text lev
    from fnd_new_messages
    where message_name = 'HR_BIS_COUNTRY'
    and application_id = 800
    and language_code = userenv('LANG')
    union
    select '3' lev_code,
           message_text lev
    from fnd_new_messages
    where message_name = 'HR_BIS_REGION'
    and application_id = 800
    and language_code = userenv('LANG');

Line: 181

  params(i).Label := htf.formSelectOpen( 'GEOLVL',NULL, NULL,
                     'OnChange="getGeog(document.params.GEOVAL, '||
                               'document.params.GEOLVL.selectedIndex)" '  );

Line: 187

                       htf.formSelectOption(ci_geog_level.lev,NULL,
                       'VALUE="'||ci_geog_level.lev_code||'"');

Line: 190

  params(i).Label := params(i).Label || htf.formSelectClose;

Line: 199

    select '-1' area_code
    ,      ' ' area
    from dual
    union
    select area_code
    ,      name area
    from bis_areas_v
    order by 2;

Line: 211

  params(i).Value := htf.formSelectOpen( 'GEOVAL' );

Line: 214

                       htf.formSelectOption(ci_area.area,NULL,
                       'VALUE="'||ci_area.area_code||'"');

Line: 217

  params(i).Value := params(i).Value || htf.formSelectClose;

Line: 226

    select '-1' id
    ,      ' ' value
    from dual
    UNION
    select id
    ,      value
    from bis_product_categories_v
    order by 2;

Line: 239

  params(i).Value := htf.formSelectOpen( 'PRODID' );

Line: 242

                       htf.formSelectOption(ci_product_category.value,NULL,
                       'VALUE="'||ci_product_category.id||'"');

Line: 245

    params(i).Value := params(i).Value || htf.formSelectClose;

Line: 280

    select '__ALL__' lookup_code
    ,      ' ' meaning
    from dual
    union
    select lookup_code, meaning
    from fnd_common_lookups
    where lookup_type = 'JOB_CATEGORIES'
    order by 2;

Line: 293

  params(i).Value := htf.formSelectOpen( 'JOBCAT' );

Line: 296

                       htf.formSelectOption(ci_job_category.meaning,NULL,
                       'VALUE="'||ci_job_category.lookup_code||'"');

Line: 299

    params(i).Value := params(i).Value || htf.formSelectClose;

Line: 308

    select lookup_code
    ,      meaning
    from hr_lookups
    where lookup_type = 'BUDGET_MEASUREMENT_TYPE'
    order by meaning;

Line: 318

  params(i).Value := htf.formSelectOpen( 'BGTTYP' );

Line: 321

                       htf.formSelectOption(ci_bgttyp.meaning, NULL,
                       'VALUE="'||ci_bgttyp.lookup_code||'"');

Line: 324

    params(i).Value := params(i).Value || htf.formSelectClose;

Line: 333

    select message_name,
           message_text view_by
    from fnd_new_messages
    where message_name = 'HR_BIS_TIME'
    and application_id = 800
    and language_code = userenv('LANG')
    union
    select message_name,
           message_text view_by
    from fnd_new_messages
    where message_name = 'HR_BIS_GEOGRAPHY'
    and application_id = 800
    and language_code = userenv('LANG')
    union
    select message_name,
           message_text view_by
    from fnd_new_messages
    where message_name = 'HR_BIS_PRODUCT'
    and application_id = 800
    and language_code = userenv('LANG')
    order by 1 desc;

Line: 359

  params(i).Value := htf.formSelectOpen( 'VIEWBY' );

Line: 362

                       htf.formSelectOption(ci_view_by.view_by,NULL,
                       'VALUE="'||ci_view_by.message_name||'"');

Line: 365

    params(i).Value := params(i).Value || htf.formSelectClose;

Line: 374

    select lookup_code,meaning
    from hr_lookups
    where lookup_type = 'PROC_PERIOD_TYPE'
    and lookup_code in ('CM','BM','Q','SY','Y')
    order by decode(lookup_code, 'CM',1, 'BM',2, 'Q',3, 'SY',6, 'Y',12, 99);

Line: 384

  params(i).Value := htf.formSelectOpen( 'FRQNCY' );

Line: 387

                       htf.formSelectOption(ci_frequency.meaning, NULL,
                       'VALUE="'||ci_frequency.lookup_code||'"');

Line: 390

    params(i).Value := params(i).Value || htf.formSelectClose;

Line: 420

    select '-1' area_code
    ,      ' ' area
    from dual
    union
    select area_code
    ,      name area
    from bis_areas_v
    order by 2;

Line: 431

    select '-1' territory_code
    ,      ' ' country
    from dual
    union
    select territory_code
    , replace(territory_short_name,'''','_') country
    from fnd_territories_vl
    order by 2;

Line: 442

    select '-1' region_code
    ,      ' ' region
    from dual
    union
    select region_code
    ,      name region
    from bis_regions_v
    order by 2;