APPS.MSC_ATP_PROC dependencies on DUAL

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

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

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

5470: END IF;
5471:
5472: -- Initialize return status and sysdate.
5473: x_return_status := FND_API.G_RET_STS_SUCCESS;
5474: SELECT TRUNC(sysdate) INTO l_sysdate FROM dual;
5475:
5476: SELECT
5477: DECODE(MSRA.ASSIGNMENT_TYPE,
5478: 1, 9,