APPS.HR_GB_UTILITY dependencies on DUAL

Line 63: select 1 from dual where exists

59: --
60: cursor csr_lookup_code(c_lookup_type in varchar2,
61: c_lookup_code in varchar2,
62: c_effective_date in date) is
63: select 1 from dual where exists
64: (select hlu.lookup_code
65: from hr_lookups hlu
66: where hlu.lookup_type = c_lookup_type
67: and hlu.lookup_code = c_lookup_code

Line 471: into l_part2 from dual;

467: decode(p_first_name,'','',null,'',p_first_name || ' ') ||
468: decode(p_middle_names,'','',null,'',p_middle_names) ,
469: 1,240)
470: )
471: into l_part2 from dual;
472:
473: if length(l_part2) > 1 then
474: select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
475: into l_full_name from dual;

Line 475: into l_full_name from dual;

471: into l_part2 from dual;
472:
473: if length(l_part2) > 1 then
474: select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
475: into l_full_name from dual;
476: else
477: Select trim(substr(decode(p_last_name,'','',null,'',p_last_name),1,240))
478: into l_full_name from dual;
479: end if;

Line 478: into l_full_name from dual;

474: select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
475: into l_full_name from dual;
476: else
477: Select trim(substr(decode(p_last_name,'','',null,'',p_last_name),1,240))
478: into l_full_name from dual;
479: end if;
480: */
481:
482: -- Note this is only a select because PL/SQL can't cope with DECODEs

Line 493: FROM sys.dual ;

489: DECODE(p_suffix,'','',' '||p_suffix)||
490: DECODE(p_known_as,'','',
491: ' ('||p_known_as||')'),1,240))
492: INTO l_full_name
493: FROM sys.dual ;
494: --
495: --
496:
497: return l_full_name;