DBA Data[Home] [Help]

APPS.PA_BILLING_PROCESS_PKG dependencies on DUAL

Line 193: FROM dual

189: BEGIN
190: /* Hint added for bug 8644400, Modified below query for bug 8813330*/
191: SELECT 1
192: INTO temp
193: FROM dual
194: WHERE EXISTS(
195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1
196: FROM pa_expenditure_items_all ei,
197: pa_tasks Rtask

Line 265: FROM dual

261: BEGIN
262: /* Modified below query for bug 8813330*/
263: SELECT 1
264: INTO temp
265: FROM dual
266: WHERE
267: EXISTS(
268: SELECT 1
269: FROM pa_events ev,

Line 326: FROM dual

322: -- For project level events
323: BEGIN
324: SELECT 1
325: INTO temp
326: FROM dual
327: WHERE EXISTS(
328: SELECT 1
329: FROM pa_events ev,
330: pa_cust_event_rev_dist_lines erdl,

Line 374: FROM dual

370: --Billing extension
371: BEGIN
372: SELECT 1
373: INTO temp
374: FROM dual
375: WHERE EXISTS(
376: SELECT 1
377: FROM pa_billing_extensions be,
378: pa_billing_assignments bea