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 3157: from dual

3153: Begin
3154:
3155: Select 1
3156: into x_count
3157: from dual
3158: where exists
3159: (select 1
3160: from gms_event_attribute
3161: where request_id = X_request_id

Line 6945: from dual;

6941:
6942: /* ------ GROUP BY CHANGES ------- */
6943: select instr(UPPER(X_LABOR_CONCAT_SELECT),'SUM',1,1)
6944: into X_position
6945: from dual;
6946:
6947: if x_position=0 then
6948: sql_orderby := ' order by ';
6949: elsif x_position >0 then

Line 7084: from dual;

7080: x_position := 0;
7081:
7082: select instr(UPPER(X_NON_LABOR_CONCAT_SELECT),'SUM',1,1)
7083: into X_position
7084: from dual;
7085:
7086: if x_position=0 then
7087: sql_orderby := ' order by ';
7088: elsif x_position >0 then