APPS.CSF_DEBRIEF_PVT dependencies on DUAL

Line 311: FROM dual;

307: null;
308: else
309: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
310: INTO l_debrief_number
311: FROM dual;
312: end if;
313: ELSE
314: SELECT CSF_DEBRIEF_HEADERS_S1.nextval
315: INTO l_debrief_header_id

Line 316: FROM dual;

312: end if;
313: ELSE
314: SELECT CSF_DEBRIEF_HEADERS_S1.nextval
315: INTO l_debrief_header_id
316: FROM dual;
317: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
318: null;
319: else
320: SELECT CSF_DEBRIEF_HEADERS_S2.nextval

Line 322: FROM dual;

318: null;
319: else
320: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
321: INTO l_debrief_number
322: FROM dual;
323: end if;
324: END IF;
325: X_DEBRIEF_HEADER_ID:=l_debrief_header_id;
326: validate_travel_times(p_debrief_rec.TRAVEL_START_TIME,

Line 1444: FROM dual;

1440: ELSE
1441:
1442: SELECT CSF_DEBRIEF_LINES_S.nextval
1443: INTO l_debrief_line_id
1444: FROM dual;
1445: END IF;
1446:
1447: -- Invoke table handler(debrief_Line_Insert_Row)
1448: csf_debrief_lines_pkg.INSERT_ROW(

Line 3542: from dual;

3538:
3539:
3540: cursor c_hours_uom is
3541: select fnd_profile.value('CSF_UOM_HOURS')
3542: from dual;
3543:
3544: l_uom varchar2(3);
3545: l_t_uom varchar2(3);
3546: