APPS.CN_PURGE_TABLES_PUB dependencies on DUAL

Line 168: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

164: x_msg_data := ':';
165: x_return_status := 'S';
166: l_error_msg := '';
167:
168: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;
169:
170: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: START l_time ' || l_time );
171: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: x_org_id: ' || p_org_id);
172: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: x_start_period_name: ' || p_start_period_name);

Line 386: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

382: p_worker_id => p_worker_id,
383: p_batch_size => p_batch_size,
384: p_request_id => g_request_id) ;
385: END IF;
386: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;
387:
388: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: x_msg_count: ' || x_msg_count);
389: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: x_msg_data: ' || x_msg_data);
390: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables: x_return_status: ' || x_return_status);