APPS.INV_TXN_VALIDATIONS dependencies on DUAL

Line 14: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

10: l_msg VARCHAR2(5100);
11: l_ts VARCHAR2(30);
12: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
15: l_msg:=l_ts||' '||msg;
16:
17:
18: IF (l_debug = 1) THEN

Line 3933: FROM dual;

3929:
3930: IF p_transaction_header_id IS NULL THEN
3931: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3932: INTO x_transaction_header_id
3933: FROM dual;
3934: ELSE
3935: x_transaction_header_id := p_transaction_header_id;
3936: END IF;
3937: