APPS.HRI_PARAMETERS SQL Statements

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

Line: 34

 select count(*)+1
 from   per_jobs            -- bug fix 3680782
 where  business_group_id = Hr_General.Get_Business_Group_Id;

Line: 668

    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: 683

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

Line: 688

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

Line: 692

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

Line: 704

    select '1'          lev_code,
           message_text lev
    from   fnd_new_messages
    where  message_name = 'HR_BIS_AREA'
    and    application_id = 453
    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 = 453
    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 = 453
    and    language_code = userenv('LANG');

Line: 729

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

Line: 736

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

Line: 740

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

Line: 755

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

Line: 760

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

Line: 764

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

Line: 776

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

Line: 789

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

Line: 794

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

Line: 798

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

Line: 813

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

Line: 825

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

Line: 827

                     htf.formSelectOption('    ',NULL, 'VALUE="__ALL__"');

Line: 831

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

Line: 835

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

Line: 838

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

Line: 841

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

Line: 844

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

Line: 848

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

Line: 850

                     htf.formSelectOption('    ',NULL, 'VALUE="__ALL__"');

Line: 853

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

Line: 856

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

Line: 860

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

Line: 862

                     htf.formSelectOption('    ',NULL, 'VALUE="__ALL__"');

Line: 865

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

Line: 868

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

Line: 886

  select b.budget_id, b.budget_name
  from pqh_budgets b ,pqh_budget_versions bv
  where b.business_group_id = g_bus_id
  and   b.budget_id = bv.budget_id
  and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 )
  order by b.budget_name ;

Line: 899

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

Line: 904

                       htf.formSelectOption(ci_bgt_id.budget_name, NULL,
                       'VALUE="'||ci_bgt_id.budget_id||'"');

Line: 911

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

Line: 929

  select b.budget_id, b.name
  from per_budgets b ,per_budget_versions bv
  where b.business_group_id = g_bus_id
  and b.budget_id = bv.budget_id
  and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 )
  order by b.name ;

Line: 943

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

Line: 948

                       htf.formSelectOption(ci_bgt_id.name, NULL,
                       'VALUE="'||ci_bgt_id.budget_id||'"');

Line: 955

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

Line: 973

    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: 985

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

Line: 990

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

Line: 994

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

Line: 1010

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

Line: 1022

    select '-1' region_code, ' ' region
    from dual
    union
    select lookup_code region_code, meaning region
    from fnd_lookups
    where lookup_type = 'REGION'
    order by 2;

Line: 1103

  select b.budget_id, b.name
  from per_budgets b ,per_budget_versions bv
  where b.business_group_id = g_bus_id
  and b.budget_id = bv.budget_id
  and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 );

Line: 1112

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

Line: 1116

                       htf.formSelectOption(ci_bgt_id.name, NULL,
                       'VALUE="'||ci_bgt_id.budget_id||'"');

Line: 1122

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

Line: 1141

  select competence_id, name
  from   per_competences_vl
  where  business_group_id = g_bus_id
  or     business_group_id is null -- bug 2518364 dsheth Sep 3, 2002
  order  by 2;

Line: 1153

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

Line: 1157

                       htf.formSelectOption(ci_compid.name, NULL,
                       'VALUE="'||ci_compid.competence_id||'"');

Line: 1164

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

Line: 1186

  select c.currency_code , c.name
  from per_business_groups b , fnd_currencies_vl c
  where b.business_group_id = hr_bis.get_sec_profile_bg_id     -- bug 2968520
  and c.enabled_flag = 'Y'
  and sysdate between nvl(c.start_date_active, hr_general.start_of_time)
  and nvl(c.end_date_active, hr_general.end_of_time)
  order by decode(b.currency_code, c.currency_code, 1,2) , c.currency_code;

Line: 1198

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

Line: 1202

                       htf.formSelectOption(ci_currcd.currency_code||' - '||ci_currcd.name, NULL,
                       'VALUE="'||ci_currcd.currency_code||'"');

Line: 1206

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

Line: 1232

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

Line: 1233

   params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_TOP'), NULL, 'VALUE="'||'HR_BIS_TOP'||'"');

Line: 1234

   params(i).Value := params(i).Value || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_BOTTOM'), NULL, 'VALUE="'||'HR_BIS_BOTTOM'||'"');

Line: 1236

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

Line: 1238

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

Line: 1243

       params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');

Line: 1246

   params(i).Value := params(i).Value || htf.formSelectOption(10, 'Yes', 'VALUE="10"');

Line: 1250

       params(i).Value := params(i).Value || htf.formSelectOption(inc_val, NULL, 'VALUE="'||inc_val||'"');

Line: 1256

       params(i).Value := params(i).Value || htf.formSelectOption(inc_amt*inc_val, NULL, 'VALUE="'||inc_amt*inc_val||'"');

Line: 1263

       params(i).Value := params(i).Value || htf.formSelectOption(inc_amt*inc_val, NULL, 'VALUE="'||inc_amt*inc_val||'"');

Line: 1266

   params(i).Value := params(i).Value || htf.formSelectOption('99', NULL, 'VALUE="99"');

Line: 1268

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

Line: 1284

  select message_name , message_text
  from fnd_new_messages
  where message_name in ('HR_BIS_INCLUDE','HR_BIS_EXCLUDE')
  and language_code = userenv('LANG')
  and application_id = 453
  order by decode(message_name,'HR_BIS_EXCLUDE','1,2');

Line: 1294

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

Line: 1298

                       htf.formSelectOption(ci_exccur.message_text, NULL,
                       'VALUE="'||ci_exccur.message_name||'"');

Line: 1302

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

Line: 1322

  select grade_id,name
  from per_grades
  where business_group_id = g_bus_id
  order by name;

Line: 1330

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

Line: 1331

  params(i).Value := params(i).Value || htf.formSelectOption('    ', NULL, 'VALUE="-1"');

Line: 1335

                       htf.formSelectOption(ci_grd_id.name, NULL,
                       'VALUE="'||ci_grd_id.grade_id||'"');

Line: 1339

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

Line: 1356

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

Line: 1358

                     || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_EMPL_IN_JOB'),
                     NULL,
                     'VALUE="E"');

Line: 1362

                     || htf.formSelectOption(fnd_message.get_string( 'HRI' ,'HR_BIS_CURRENT_APPL_FOR_JOB'),
                     NULL,
                     'VALUE="A"');

Line: 1366

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

Line: 1388

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

Line: 1393

                     htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')
                     || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),
                     NULL, 'VALUE="HR_BIS_TOTAL"');

Line: 1397

                     htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')
                     || ' ' || fnd_message.get_string('HRI', 'HR_BIS_SEPARATED'),
                     NULL, 'VALUE="HR_BIS_PERCENT"');

Line: 1403

                     htf.formSelectOption(fnd_message.get_string('HRI', 'HR_BIS_PERCENT')
                     || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
                     NULL, 'VALUE="HR_BIS_PERCENT"');

Line: 1407

                     htf.formSelectOption(fnd_message.get_string('HRI' ,'HR_BIS_TOTAL')
                     || ' ' || fnd_message.get_string('HRI', 'HR_BIS_INCREASE'),
                     NULL, 'VALUE="HR_BIS_TOTAL"');

Line: 1412

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

Line: 1439

  select meaning, lookup_code
  from hr_lookups
  where lookup_type = 'YES_NO'
  and lookup_code IN ('Y', 'N');

Line: 1456

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

Line: 1471

                     htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISRO"');

Line: 1475

                     htf.formSelectOption(lookup_no,  'Yes', 'VALUE="ISNR"');

Line: 1481

                     htf.formSelectOption(lookup_yes, NULL, 'VALUE="ISNR"');

Line: 1483

                     htf.formSelectOption(lookup_no,  NULL, 'VALUE="SINR"');

Line: 1488

                     htf.formSelectOption(lookup_yes, NULL, 'VALUE="SIRO"');

Line: 1490

                     htf.formSelectOption(lookup_no,  NULL, 'VALUE="SINR"');

Line: 1493

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

Line: 1510

  select DISTINCT payroll_id , payroll_name
  from pay_payrolls_f
  where business_group_id = g_bus_id
  order by payroll_name;

Line: 1522

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

Line: 1525

     params(i).Value := params(i).Value || htf.formSelectOption('    ', NULL, 'VALUE="-1"');

Line: 1530

                       htf.formSelectOption(ci_payrll.payroll_name, NULL,
                       'VALUE="'||ci_payrll.payroll_id||'"');

Line: 1537

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

Line: 1594

  select lookup_code,meaning
  from  hr_lookups   /* bug fix 3323544*/
  where lookup_type = p_lookup_type
  and enabled_flag = 'Y' /* bug fix 1608726 */
  order by 2;

Line: 1603

  params(i).Value := htf.formSelectOpen(P_FORM_NAME);

Line: 1606

     params(i).Value := params(i).Value || htf.formSelectOption('    ', NULL, 'VALUE="' || P_ALL_OPTION || '"');

Line: 1611

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

Line: 1615

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

Line: 1634

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

Line: 1636

                     htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_MINIMUM_PROFICIENCY'),
                     NULL,
                     'VALUE="M"');

Line: 1640

                     htf.formSelectOption(fnd_message.get_string('HRI','HR_BIS_PROFICIENCY_RANGE'),
                     NULL,
                     'VALUE="R"');

Line: 1644

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

Line: 1662

  select message_name , message_text
  from fnd_new_messages
  where language_code = userenv('LANG')
  and application_id  = 453
  and message_name in ('HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING', 'HR_BIS_SERVICE_BAND',
                       'HR_BIS_JOB', 'HR_BIS_LOCATION', 'HR_BIS_GENDER')
  UNION
  select message_name , message_text
  from fnd_new_messages , per_business_groups
  where business_group_id = hr_bis.get_sec_profile_bg_id    -- bug 2968520
  and legislation_code = 'US'
  and language_code = userenv('LANG')
  and application_id  = 453
  and message_name = 'HR_BIS_EEO_CATEGORY'
  UNION
  select message_name , message_text
  from fnd_new_messages fnm , per_business_groups bus
  where bus.business_group_id = hr_bis.get_sec_profile_bg_id    -- bug 2968520
  and language_code = userenv('LANG')
  and application_id  = 453
  and legislation_code <> 'US'
  and message_name = 'HR_BIS_ETHNIC_ORIGIN' order by 2;

Line: 1686

  select message_name , message_text
  from fnd_new_messages
  where language_code = userenv('LANG')
  and application_id  = 453
  and message_name in ('HR_BIS_AGE_YEARS', 'HR_BIS_LOS_YEARS', 'HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING')
  order by message_name;

Line: 1694

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

Line: 1705

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

Line: 1710

            htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');

Line: 1715

            htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');

Line: 1720

             htf.formSelectOption(ci_viewby.message_text, NULL, 'VALUE="'||ci_viewby.message_name||'"');

Line: 1724

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

Line: 1769

select organization_id, organization_name
from hri_org_lov_v
order by organization_name;

Line: 1777

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

Line: 1780

     params(i).Value := params(i).Value || htf.formSelectOption('    ', NULL, 'VALUE="-1"');

Line: 1785

                       htf.formSelectOption(ci_org_list.organization_name, NULL,
                       'VALUE="'||ci_org_list.organization_id||'"');

Line: 1790

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

Line: 1804

select job_id, name job_name
from   per_jobs            -- bug fix 3680782
where  business_group_id = Hr_General.Get_Business_Group_Id
order by name;	-- use of p_option = 1

Line: 1814

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

Line: 1817

     params(i).Value := params(i).Value || htf.formSelectOption('    ', NULL, 'VALUE="-1"');

Line: 1822

                       htf.formSelectOption(ci_job_list.job_name, NULL,
                       'VALUE="'||ci_job_list.job_id||'"');

Line: 1829

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

Line: 1846

select location_id, location_name
from hri_loc_lov_v;

Line: 1852

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

Line: 1855

     params(i).Value := params(i).Value || htf.formSelectOption('    ', NULL, 'VALUE="-1"');

Line: 1860

                       htf.formSelectOption(ci_loc_list.location_name, NULL,
                       'VALUE="'||ci_loc_list.location_id||'"');

Line: 1865

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

Line: 1988

      select substrb( web_html_call, 48, length(web_html_call)-49)
      from   fnd_form_functions
      where  function_name = 'BIS_' || cp_report;