APPS.WSH_ROUTING_RESPONSE_PKG dependencies on DUAL

Line 1341: SELECT WSH_ROUTING_RESPONSE_S.nextval INTO l_receiptNum FROM dual;

1337: wsh_debug_sv.log(l_moduleName, 'l_receiptNum', l_receiptNum);
1338: END IF;
1339: --
1340: IF c_ResponseNum%NOTFOUND THEN
1341: SELECT WSH_ROUTING_RESPONSE_S.nextval INTO l_receiptNum FROM dual;
1342: END IF;
1343: --
1344: CLOSE c_ResponseNum;
1345: --

Line 2194: INTO l_clientOrgId FROM DUAL;

2190: ELSE
2191: --{
2192: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
2193: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
2194: INTO l_clientOrgId FROM DUAL;
2195: --
2196: IF l_debugOn THEN
2197: wsh_debug_sv.log (l_moduleName, 'l_clientOrgId',l_clientOrgId);
2198: END IF;