APPS.XNP_MESSAGE dependencies on DUAL

Line 319: SELECT ( XNP_MSGS_S.nextval ) INTO x_msg_id FROM DUAL ;

315: )
316: IS
317: BEGIN
318:
319: SELECT ( XNP_MSGS_S.nextval ) INTO x_msg_id FROM DUAL ;
320:
321: END get_sequence;
322:
323: /***************************************************************************

Line 1853: FROM DUAL

1849: BEGIN
1850: l_count := 0;
1851: SELECT 1
1852: INTO l_count
1853: FROM DUAL
1854: WHERE EXISTS
1855: (SELECT 1
1856: FROM XNP_CALLBACK_EVENTS
1857: WHERE msg_code = p_msg_code);

Line 1873: FROM DUAL

1869: l_count := 0;
1870:
1871: SELECT 1
1872: INTO l_count
1873: FROM DUAL
1874: WHERE EXISTS
1875: (SELECT 1
1876: FROM XNP_MSGS
1877: WHERE msg_code=p_msg_code);

Line 1892: FROM DUAL

1888: BEGIN
1889: l_count := 0;
1890: SELECT 1
1891: INTO l_count
1892: FROM DUAL
1893: WHERE EXISTS
1894: (SELECT 1
1895: FROM XNP_TIMER_REGISTRY
1896: WHERE p_msg_code=timer_message_code);

Line 2127: select sysdate into g_logdate from dual;

2123: INTO g_logdir
2124: FROM v$parameter
2125: WHERE name = 'utl_file_dir';
2126:
2127: select sysdate into g_logdate from dual;
2128:
2129: fnd_file.put_names('XNPMSGPB'||to_char(g_logdate, 'YYYYMMDDHHMISS')||'.log',
2130: 'XNPMSGPB'||to_char(g_logdate, 'YYYYMMDDHHMISS')||'.out',
2131: g_logdir);