APPS.CSP_EXCESS_PARTS_PVT dependencies on DUAL

Line 254: SELECT Sysdate INTO l_today FROM dual;

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

Line 417: from dual;

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