APPS.MSC_ATP_PROC dependencies on DUAL

Line 353: -- SELECT trunc(sysdate) INTO l_sysdate FROM dual;

349: END IF;
350:
351: -- For bug 2585710. Store sysdate in local variable once and for all.
352: -- Replace trunc(sysdate) everwhere.
353: -- SELECT trunc(sysdate) INTO l_sysdate FROM dual;
354: -- Modified to change explicit SELECT to direct assignment.
355: l_sysdate := TRUNC(sysdate);
356:
357: IF (p_customer_id is not null) and (p_customer_site_id is not null) THEN

Line 5485: SELECT TRUNC(sysdate) INTO l_sysdate FROM dual;

5481: END IF;
5482:
5483: -- Initialize return status and sysdate.
5484: x_return_status := FND_API.G_RET_STS_SUCCESS;
5485: SELECT TRUNC(sysdate) INTO l_sysdate FROM dual;
5486:
5487: SELECT
5488: DECODE(MSRA.ASSIGNMENT_TYPE,
5489: 1, 9,