APPS.CSP_PLANNER_NOTIFICATIONS dependencies on DUAL

Line 259: SELECT Sysdate INTO l_today FROM dual;

255: END IF;
256:
257: -- initialize return status, get audit columns
258: --x_return_status := FND_API.G_RET_STS_SUCCESS;
259: SELECT Sysdate INTO l_today FROM dual;
260: l_user_id := nvl(fnd_global.user_id, 0) ;
261: l_login_id := nvl(fnd_global.login_id, -1);
262:
263: Cleanup_Notifications(p_organization_id);

Line 401: from dual;

397: END IF;
398:
399: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
400: into l_WIP_BATCH_ID
401: from dual;
402:
403: -- call to min_max API
404: CSP_MINMAX_PVT.run_min_max_plan (
405: p_item_select => l_item_select