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 144: from dual;

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

Line 214: from dual;

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