APPS.CSP_EXCESS_PARTS_PVT dependencies on DUAL

Line 256: SELECT Sysdate INTO l_today FROM dual;

252: msib.revision_qty_control_code;
253: Begin
254: SAVEPOINT Create_excess_parts_PUB;
255:
256: SELECT Sysdate INTO l_today FROM dual;
257: l_user_id := nvl(fnd_global.user_id, 0) ;
258: l_login_id := nvl(fnd_global.login_id, -1);
259:
260: FOR Rec IN PLANNING_NODE_REC LOOP

Line 419: from dual;

415: END IF;
416:
417: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
418: into l_WIP_BATCH_ID
419: from dual;
420:
421: if p_called_from <> 'PART_STATUS' and nvl(p_condition_type,'B') = 'B' then
422: defective_return(p_organization_id,
423: p_subinventory_code,