APPS.HR_HU_UTILITY dependencies on DUAL

Line 331: FROM dual;

327: ||DECODE(p_first_name,NULL, '', ' ' || p_first_name)
328: ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
329: )), 1, 240)
330: INTO l_full_name
331: FROM dual;
332:
333: RETURN l_full_name;
334: --
335: END per_hu_full_name;

Line 384: FROM dual;

380: BEGIN
381: --
382: SELECT SUBSTR(TRIM(NVL(p_pre_name_adjunct,p_last_name)), 1, 240)
383: INTO l_order_name
384: FROM dual;
385:
386: RETURN(l_order_name);
387: --
388: END per_hu_order_name;

Line 450: FROM sys.dual

446: --
447: BEGIN
448: SELECT 'Y'
449: INTO l_status
450: FROM sys.dual
451: WHERE exists(SELECT '1'
452: FROM per_all_people_f pp
453: WHERE (p_person_id IS NULL
454: OR p_person_id <> pp.person_id)