DBA Data[Home] [Help]

APPS.WF_LOAD dependencies on DUAL

Line 1761: from sys.dual;

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

Line 2453: from sys.dual

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

Line 2620: from sys.dual

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

Line 3709: -- from sys.dual

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