APPS.HR_SA_HIJRAH_FUNCTIONS dependencies on DUAL

Line 48: from dual;

44: )
45: ,'YYYY/MM/DD'
46: )
47: into l_date
48: from dual;
49: hr_utility.set_location('l_date '|| l_date,3);
50: -- hr_utility.trace_off;
51: /*
52: l_cnt1 := floor(l_hij_year * 354.36887);

Line 141: from dual ;

137: )
138: ,'YYYY/MM/DD','NLS_CALENDAR=''ENGLISH HIJRAH'''
139: )
140: into l_hij_date
141: from dual ;
142: hr_utility.set_location('l_hij_date '|| l_hij_date,2);
143: -- hr_utility.trace_off;
144: return (l_hij_date);
145: else

Line 195: from dual;

191: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
192: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
193: select ltrim(rtrim(to_char(l_greg_date,'D')))
194: into l_day
195: from dual;
196: return(hr_general.decode_lookup('SA_HIJRAH_DAYS',l_day));
197: end get_day;
198:
199: function get_month

Line 222: from dual;

218: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
219: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
220: select ltrim(rtrim(to_char(l_greg_date,'D')))
221: into l_day
222: from dual;
223: return(l_day);
224: end get_weekday;
225:
226: function get_yearday