APPS.HR_GCC_HIJRAH_FUNCTIONS dependencies on DUAL

Line 159: from dual;

155: hr_gcc_hijrah_functions.validate_date(p_input_date,l_input_date);
156: l_greg_date := to_date(hr_gcc_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
157: select ltrim(rtrim(to_char(l_greg_date,'D')))
158: into l_day
159: from dual;
160: return(hr_general.decode_lookup('GCC_HIJRAH_DAYS',l_day));
161: end get_day;
162:
163: function get_month

Line 186: from dual;

182: hr_gcc_hijrah_functions.validate_date(p_input_date,l_input_date);
183: l_greg_date := to_date(hr_gcc_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
184: select ltrim(rtrim(to_char(l_greg_date,'D')))
185: into l_day
186: from dual;
187: return(l_day);
188: end get_weekday;
189:
190: function get_yearday