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 491: into l_part2 from dual;

487: decode(p_first_name,'','',null,'',p_first_name || ' ') ||
488: decode(p_middle_names,'','',null,'',p_middle_names) ,
489: 1,240)
490: )
491: into l_part2 from dual;
492:
493: if length(l_part2) > 1 then
494: select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
495: into l_full_name from dual;

Line 495: into l_full_name from dual;

491: into l_part2 from dual;
492:
493: if length(l_part2) > 1 then
494: select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
495: into l_full_name from dual;
496: else
497: Select trim(substr(decode(p_last_name,'','',null,'',p_last_name),1,240))
498: into l_full_name from dual;
499: end if;

Line 498: into l_full_name from dual;

494: select trim(substr(decode(p_last_name,'','',null,'',p_last_name || ', ') || l_part2,1,240))
495: into l_full_name from dual;
496: else
497: Select trim(substr(decode(p_last_name,'','',null,'',p_last_name),1,240))
498: into l_full_name from dual;
499: end if;
500: */
501:
502: -- Note this is only a select because PL/SQL can't cope with DECODEs

Line 513: FROM sys.dual ;

509: DECODE(p_suffix,'','',' '||p_suffix)||
510: DECODE(p_known_as,'','',
511: ' ('||p_known_as||')'),1,240))
512: INTO l_full_name
513: FROM sys.dual ;
514: --
515: --
516:
517: return l_full_name;