APPS.CN_NOTIFICATION_PUB dependencies on DUAL

Line 253: FROM DUAL;

249: ),
250: -99
251: )
252: INTO l_org_id
253: FROM DUAL;
254: END IF;
255:
256: -- Call to Collection_Required makes sure that there is not
257: -- already a 'to-be-collected' record for the line in CN_NOT_TRX_ALL.

Line 286: FROM DUAL;

282: SELECT FLOOR(cn_not_trx_s.CURRVAL/NVL(cn_global_var.g_system_batch_size,200)),
283: cn_not_trx_s.NEXTVAL
284: INTO l_batch_id,
285: l_not_trx_id
286: FROM DUAL;
287: --+
288: -- Insert a new row for this source_trx_line into cn_not_trx_all,
289: -- with collected_flag = 'N'
290: --+