APPS.INV_CG_UPGRADE dependencies on DUAL

Line 494: select sysdate into l_date from dual;

490: ** Delete data. It will be reloaded from memory in just a second
491: */
492: delete mtl_period_summary WHERE organization_id = l_organization_id;
493:
494: select sysdate into l_date from dual;
495:
496: l_user_id := fnd_global.user_id;
497: l_login_id := fnd_global.login_id;
498:

Line 567: select sysdate into l_date from dual;

563: l_ps_tbl(l_counter).cost_group_id := c2.cost_group_id;
564: l_ps_tbl(l_counter).inventory_value := c2.inventory_value;
565: end loop;
566: delete mtl_period_summary WHERE organization_id = l_organization_id;
567: select sysdate into l_date from dual;
568:
569: l_user_id := fnd_global.user_id;
570: l_login_id := fnd_global.login_id;
571:

Line 1476: from dual

1472: --using rownum=1 logic. Also break the query for the date condition.
1473: begin
1474: select 1
1475: into l_dummy
1476: from dual
1477: where exists (SELECT cost_group_id
1478: FROM mtl_material_transactions
1479: WHERE organization_id = l_organization_id
1480: and cost_group_id is not null

Line 1498: from dual

1494: --bug5073454
1495: begin
1496: select 1
1497: into l_dummy
1498: from dual
1499: where exists (SELECT cost_group_id
1500: FROM mtl_material_transactions
1501: WHERE organization_id = l_organization_id
1502: and cost_group_id is not null