[Home] [Help]
123: select null
124: from pa_draft_invoices
125: where (project_id, draft_invoice_num) in
126: (select project_id,draft_invoice_num
127: from pa_cust_rev_dist_lines
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