APPS.HR_NO_UTILITY dependencies on DUAL

Line 74: FROM dual;

70: ||DECODE(p_middle_name,NULL, '', ' ' || LTRIM(RTRIM(p_middle_name)))
71: ||' '||LTRIM(p_last_name))
72: ), 1, 240)
73: INTO l_full_name
74: FROM dual;
75:
76: --
77: --
78: -- Return Full name

Line 149: FROM dual;

145: --
146:
147: SELECT SUBSTR(TRIM(p_last_name)||' '||TRIM(p_first_name), 1, 240)
148: INTO l_order_name
149: FROM dual;
150:
151: --
152: --
153: -- Return the Order Name