APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on DUAL

Line 229: SELECT sysdate INTO timebefore from dual;

225: fnd_log.string(fnd_log.level_statement,l_debug_module,'Polling for pending routes');
226: END IF;
227:
228: --snarkhed::ENigma Phase II change in the interface logic
229: SELECT sysdate INTO timebefore from dual;
230: OPEN get_op_data;
231: LOOP
232: FETCH get_op_data INTO l_cur_op_data_rec;
233: EXIT WHEN get_op_data%NOTFOUND;

Line 269: SELECT sysdate INTO timebefore from dual;

265: DELETE FROM AHL_ENIGMA_OP_INTERFACE
266: WHERE ISRECOVERABLE = 'Y'
267: AND PROCESS_DATE <= timebefore;
268:
269: SELECT sysdate INTO timebefore from dual;
270: OPEN get_route_data;
271: LOOP
272: FETCH get_route_data INTO l_cur_route_data_rec;
273: EXIT WHEN get_route_data%NOTFOUND;

Line 1880: FROM DUAL;

1876: p_process_oper_input_rec.SEGMENT6 := p_enigma_op_rec.OP_SEQ;
1877: ELSIF ( p_enigma_op_rec.OP_SEQ IS NULL OR p_enigma_op_rec.OP_SEQ = FND_API.G_MISS_CHAR) THEN
1878: SELECT AHL_ENIGMA_OP_SEQ_S.NEXTVAL
1879: INTO l_op_sq
1880: FROM DUAL;
1881: p_process_oper_input_rec.SEGMENT6 := l_op_sq || fnd_profile.value('AHL_ENIGMA_OP_SEQ');
1882: END IF;
1883:
1884: IF (p_enigma_op_rec.CONFIG_LETTER <> FND_API.G_MISS_CHAR AND p_enigma_op_rec.CONFIG_LETTER IS NOT NULL ) THEN

Line 2483: select fnd_lobs_s.nextval into seqNo from dual;

2479:
2480: dbms_lob.fileclose(l_inputFilePtr);
2481: dbms_lob.close(l_contentBlob);
2482:
2483: select fnd_lobs_s.nextval into seqNo from dual;
2484:
2485: insert into fnd_lobs(
2486: file_id,
2487: file_name,