DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on PA_DRAFT_INVOICE_ITEMS

Line 1239: from pa_events p,pa_draft_invoice_items i

1235: select nvl(sum(bill_quantity),0)
1236: from oke_k_billing_events e
1237: where Deliverable_Id = P_Deliverable_Id
1238: and exists ( Select 'Y'
1239: from pa_events p,pa_draft_invoice_items i
1240: where p.event_id=e.pa_event_id
1241: --and i.draft_inv_line_num_credited is null
1242: and p.event_num=i.event_num
1243: and p.project_id=i.project_id