APPS.GMS_BILLING dependencies on DUAL

Line 110: select 1 into l_dummy from dual where exists (

106: End If;
107:
108: --Commented columns containing 'Job' for Bug# 5003907
109: Begin
110: select 1 into l_dummy from dual where exists (
111: select 1
112: from pa_invoice_group_columns a,
113: pa_invoice_format_details b
114: where a.invoice_group_column_id = b.invoice_group_column_id

Line 171: from dual

167: BEGIN
168:
169: Select 1
170: into x_dummy
171: from dual
172: where exists (select 1
173: from gms_event_intersect
174: where award_project_id = X_Award_Project_Id
175: and request_id = X_Request_Id

Line 224: from dual

220: RETURN FALSE;
221: else
222: Select 1
223: into l_value
224: from dual
225: where exists(
226: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
227: from gms_award_distributions adl,
228: pa_tasks t3,

Line 269: from dual

265: return FALSE;
266: else
267: Select 1
268: into l_value
269: from dual
270: where exists(
271: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
272: from
273: gms_award_distributions adl,

Line 3132: from dual

3128: Begin
3129:
3130: Select 1
3131: into x_count
3132: from dual
3133: where exists
3134: (select 1
3135: from gms_event_attribute
3136: where request_id = X_request_id

Line 6914: from dual;

6910:
6911: /* ------ GROUP BY CHANGES ------- */
6912: select instr(UPPER(X_LABOR_CONCAT_SELECT),'SUM',1,1)
6913: into X_position
6914: from dual;
6915:
6916: if x_position=0 then
6917: sql_orderby := ' order by ';
6918: elsif x_position >0 then

Line 7053: from dual;

7049: x_position := 0;
7050:
7051: select instr(UPPER(X_NON_LABOR_CONCAT_SELECT),'SUM',1,1)
7052: into X_position
7053: from dual;
7054:
7055: if x_position=0 then
7056: sql_orderby := ' order by ';
7057: elsif x_position >0 then