APPS.CSF_DEBRIEF_PVT dependencies on DUAL

Line 324: FROM dual;

320: null;
321: else
322: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
323: INTO l_debrief_number
324: FROM dual;
325: end if;
326: ELSE
327: SELECT CSF_DEBRIEF_HEADERS_S1.nextval
328: INTO l_debrief_header_id

Line 329: FROM dual;

325: end if;
326: ELSE
327: SELECT CSF_DEBRIEF_HEADERS_S1.nextval
328: INTO l_debrief_header_id
329: FROM dual;
330: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
331: null;
332: else
333: SELECT CSF_DEBRIEF_HEADERS_S2.nextval

Line 335: FROM dual;

331: null;
332: else
333: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
334: INTO l_debrief_number
335: FROM dual;
336: end if;
337: END IF;
338: X_DEBRIEF_HEADER_ID:=l_debrief_header_id;
339: validate_travel_times(p_debrief_rec.TRAVEL_START_TIME,

Line 1477: FROM dual;

1473: ELSE
1474:
1475: SELECT CSF_DEBRIEF_LINES_S.nextval
1476: INTO l_debrief_line_id
1477: FROM dual;
1478: END IF;
1479:
1480: --dbms_output.put_line('Calling INSERT_ROW...');
1481: -- Invoke table handler(debrief_Line_Insert_Row)

Line 3986: from dual;

3982:
3983:
3984: cursor c_hours_uom is
3985: select fnd_profile.value('CSF_UOM_HOURS')
3986: from dual;
3987:
3988: l_uom varchar2(3);
3989: l_t_uom varchar2(3);
3990: