DBA Data[Home] [Help]

APPS.CONVERT_TEST dependencies on DUAL

Line 390: select sysdate into l_date from dual;

386: ** Delete data. It will be reloaded from memory in just a second
387: */
388: delete mtl_period_summary WHERE organization_id = l_organization_id;
389:
390: select sysdate into l_date from dual;
391:
392: l_user_id := fnd_global.user_id;
393: l_login_id := fnd_global.login_id;
394:

Line 1320: into l_date from dual;

1316: -- create table mmt_summary(MSG VARCHAR2(1000))
1317: -- and uncomment next 6 lines
1318: /*
1319: select to_char(sysdate, 'DD-MON-YY HH24:MI:SS')
1320: into l_date from dual;
1321:
1322: insert into mmt_summary values('Org ' ||
1323: to_char(l_organization_id) ||
1324: ':' || l_date);