DBA Data[Home] [Help]

APPS.HR_CA_UTILITY dependencies on DUAL

Line 71: FROM sys.dual ;

67: ' '||p_first_name)||DECODE(p_middle_names,'','',
68: ' '||p_middle_names)||
69: DECODE(p_suffix,'','',' '||p_suffix),1,240)
70: INTO l_full_name
71: FROM sys.dual ;
72:
73: hr_utility.set_location('hr_us_utility',1);
74: return l_full_name;
75: --

Line 134: FROM sys.dual ;

130: DECODE(p_suffix,'','',' '||p_suffix)||
131: DECODE(p_known_as,'','',
132: ' ('||p_known_as||')'),1,240)
133: INTO l_order_name
134: FROM sys.dual ;
135:
136: return (l_order_name);
137: --
138: END;