APPS.OKE_BILLING_EVENT_PUB dependencies on PA_DRAFT_INVOICES_ALL

Line 1245: and exists( select 'X' from pa_draft_invoices_all iv

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
1244: and nvl(p.task_id,0)=nvl(i.task_id,0)
1245: and exists( select 'X' from pa_draft_invoices_all iv
1246: where iv.project_id=i.project_id and iv.draft_invoice_num=i.draft_invoice_num and iv.canceled_flag='Y')
1247: and pa_events_pkg.is_event_billed(p.project_id,p.task_id,p.event_num,p.Bill_trans_bill_amount)='N');
1248:
1249: L_Can_qty Number;