APPS.HR_HU_UTILITY dependencies on DUAL

Line 284: FROM dual;

280: ||DECODE(p_first_name,NULL, '', ' ' || p_first_name)
281: ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
282: )), 1, 240)
283: INTO l_full_name
284: FROM dual;
285:
286: RETURN l_full_name;
287: --
288: END per_hu_full_name;

Line 337: FROM dual;

333: BEGIN
334: --
335: SELECT SUBSTR(TRIM(NVL(p_pre_name_adjunct,p_last_name)), 1, 240)
336: INTO l_order_name
337: FROM dual;
338:
339: RETURN(l_order_name);
340: --
341: END per_hu_order_name;

Line 403: FROM sys.dual

399: --
400: BEGIN
401: SELECT 'Y'
402: INTO l_status
403: FROM sys.dual
404: WHERE exists(SELECT '1'
405: FROM per_all_people_f pp
406: WHERE (p_person_id IS NULL
407: OR p_person_id <> pp.person_id)