DBA Data[Home] [Help]

APPS.WF_LOAD dependencies on DUAL

Line 1762: from sys.dual;

1758: -- instance_id of zero means generate locally
1759: if (x_instance_id = 0) then
1760: select WF_PROCESS_ACTIVITIES_S.NEXTVAL
1761: into x_instance_id
1762: from sys.dual;
1763:
1764: raise NO_DATA_FOUND; --jump to insert
1765: else
1766: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2454: from sys.dual

2450: -- just in case constraints are missing or disabled.
2451: begin
2452: select 1
2453: into dummy
2454: from sys.dual
2455: where not exists
2456: (select 1
2457: from WF_LOOKUP_TYPES
2458: where ITEM_TYPE = x_name)

Line 2621: from sys.dual

2617: -- just in case constraints are missing or disabled.
2618: begin
2619: select 1
2620: into dummy
2621: from sys.dual
2622: where not exists
2623: (select 1
2624: from WF_ACTIVITIES
2625: where ITEM_TYPE = x_type

Line 3710: -- from sys.dual

3706: -- The following check causes full table scans. Since it is controlled by
3707: -- constraints already, we skipped the check here.
3708: -- begin
3709: -- select 1 into dummy
3710: -- from sys.dual
3711: -- where not exists (
3712: -- select 1
3713: -- from WF_ITEM_ACTIVITY_STATUSES_V
3714: -- where ACTIVITY_ID = p_step