APPS.FND_IMP_PKG dependencies on DUAL

Line 261: select sysdate into time__ from dual;

257: OPEN bugsnaps1;
258: LOOP
259: FETCH bugsnaps1 into snapshot_id__, virtual_patch_id__, set_type__; --ang
260: EXIT WHEN bugsnaps1%NOTFOUND;
261: select sysdate into time__ from dual;
262: if(set_type__ = 'M') then
263: refresh1M(request_id__, virtual_patch_id__, snapshot_id__); --ang
264: else
265: refresh1(virtual_patch_id__, snapshot_id__); --ang

Line 351: select sysdate into time__ from dual;

347: OPEN bugsnaps2;
348: LOOP
349: FETCH bugsnaps2 into snapshot_id__, virtual_patch_id__, set_type__, psmaster2_sz__;
350: EXIT WHEN bugsnaps2%NOTFOUND;
351: select sysdate into time__ from dual;
352: refresh2(virtual_patch_id__, snapshot_id__);
353:
354: if psmaster2_sz__ = 0 then
355: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> No Patch Metadata found for patch: '||virtual_patch_id__);

Line 725: select 0-request_id__ from dual);

721: where m.set_type in ('s','S','M')
722: and m.request_id = request_id__
723: and m.snapshot_id = l.snapshot_id
724: union
725: select 0-request_id__ from dual);
726:
727: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' cleaned up fnd_imp_lang_summary');
728:
729: