[Home] [Help]
128: where project_id = X_project_id
129: and draft_revenue_num = X_draft_revenue_num
130: union
131: select project_id,draft_invoice_num
132: from pa_cust_event_rev_dist_lines
133: where project_id = X_project_id
134: and draft_revenue_num = X_draft_revenue_num
135: union /* Start of Changes for bug 5401384 -base bug 5246804 */
136: select distinct dii.project_id,dii.draft_invoice_num