DBA Data[Home] [Help]

APPS.JL_BR_WORKDAY_CALENDAR dependencies on DUAL

Line 33: from dual;

29: end if;
30:
31: select to_date(p_date,'DD-MM-YYYY')
32: into x_date
33: from dual;
34:
35: p_status:= 0;
36: flag_exit := 0;
37:

Line 102: from dual;

98: else
99: flag_exit := 1;
100: select to_char(x_date,'DD-MM-YYYY')
101: into p_new_date
102: from dual;
103: end if;
104:
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN

Line 143: from dual;

139: end if;
140:
141: select to_date(p_date,'DD-MM-YYYY')
142: into x_date
143: from dual;
144:
145: p_status:= 0;
146: flag_exit := 0;
147:

Line 213: from dual;

209: else
210: flag_exit := 1;
211: select to_char(x_date,'DD-MM-YYYY')
212: into p_new_date
213: from dual;
214: end if;
215:
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN