DBA Data[Home] [Help]

APPS.GMS_INSTALL dependencies on DUAL

Line 35: from dual where exists

31:
32: If x_org_id is NULL then
33:
34: select 1 into l_dummy
35: from dual where exists
36: (select 1
37: from gms_implementations
38: where enabled = 'Y');
39:

Line 43: from dual where exists

39:
40: Else
41:
42: select 1 into l_dummy
43: from dual where exists
44: (select 1
45: from gms_implementations
46: where org_id = x_org_id
47: and enabled = 'Y');

Line 149: select 'X' into x_temp from dual where exists (

145: begin
146: -- Bug 2254944 (CODING STANDARD VIOLATIONS TO BE FIXED) - replaced rownum with exists
147: --select 'X'
148: --into x_temp
149: select 'X' into x_temp from dual where exists (
150: select 1
151: from gms_implementations_all );
152: --where rownum < 2 ;
153: