APPS.CLN_NOTIFICATION_CODES_PKG dependencies on DUAL

Line 294: SELECT Sysdate INTO l_sysdate FROM dual;

290: l_user_id := 1;
291: END IF;
292: --
293:
294: SELECT Sysdate INTO l_sysdate FROM dual;
295: -- l_notification_id := fnd_number.canonical_to_number(X_NOTIFICATION_ID);
296:
297: BEGIN
298:

Line 306: SELECT CLN_NOTIFICATION_CODES_S.NEXTVAL INTO l_notification_id FROM DUAL;

302:
303: EXCEPTION
304: WHEN NO_DATA_FOUND then
305:
306: SELECT CLN_NOTIFICATION_CODES_S.NEXTVAL INTO l_notification_id FROM DUAL;
307:
308: insert into CLN_NOTIFICATION_CODES_B (
309: NOTIFICATION_ID,
310: COLLABORATION_POINT,