[Home] [Help]
266: WHERE
267: EXISTS(
268: SELECT 1
269: FROM pa_events ev,
270: pa_cust_event_rev_dist_lines erdl,
271: pa_draft_revenues drx,
272: pa_tasks Rtask
273: WHERE ev.project_id = Rtask.project_id
274: AND ev.task_id = Rtask.task_id
326: FROM dual
327: WHERE EXISTS(
328: SELECT 1
329: FROM pa_events ev,
330: pa_cust_event_rev_dist_lines erdl,
331: pa_draft_revenues drx
332: WHERE ev.project_id = Rproj.project_id
333: AND ev.task_id IS NULL
334: AND ((ev.revenue_distributed_flag = 'N'