APPS.HR_GB_UTILITY SQL Statements

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

Line: 63

   select 1 from dual where exists
   (select hlu.lookup_code
    from hr_lookups hlu
    where hlu.lookup_type = c_lookup_type
    and hlu.lookup_code = c_lookup_code
    and c_effective_date between
            nvl(hlu.start_date_active, p_effective_date)
       and  nvl(hlu.end_date_active, p_effective_date)
    and hlu.enabled_flag = 'Y');

Line: 225

     select formula_id,effective_start_date
     into   l_formula_id, l_effective_start_date
     from   ff_formulas_f
     where  formula_name='TAX_CODE'
     and    business_group_id is null
     and    legislation_code='GB'
     and    p_effective_date between effective_start_date and effective_end_date;

Line: 471

      SELECT meaning
      INTO   l_title
      FROM   hr_lookups
      WHERE  lookup_type = 'TITLE'
      AND    p_title     = lookup_code
      AND    application_id = 800;

Line: 484

select trim(
           substr(
         decode(l_title,'','',null,'',l_title || ' ')      ||
         decode(p_first_name,'','',null,'',p_first_name || ' ') ||
         decode(p_middle_names,'','',null,'',p_middle_names) ,
            1,240)
             )
    into l_part2 from dual;

Line: 494

      select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
         into l_full_name from dual;

Line: 497

      Select trim(substr(decode(p_last_name,'','',null,'',p_last_name),1,240))
         into l_full_name from dual;

Line: 504

  SELECT rtrim(substrb(DECODE(p_pre_name_adjunct,'','',p_pre_name_adjunct||' ')||
                      p_last_name||','||DECODE(l_title,'','',
                      ' '||l_title)||DECODE(p_first_name,'','',
                      ' '||p_first_name)||DECODE(p_middle_names,'','',
                      ' '||p_middle_names)||
                      DECODE(p_suffix,'','',' '||p_suffix)||
                      DECODE(p_known_as,'','',
                      ' ('||p_known_as||')'),1,240))
  INTO  l_full_name
  FROM sys.dual ;