DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_DRAFT_INVOICE_ITEMS

Line 172: pa_draft_invoice_items di

168: and NVL(ey.bill_hold_flag,'N') = 'N'
169: and NVL(ey.bill_trans_bill_amount,0) <> 0
170: and not exists
171: ( select 'x' from
172: pa_draft_invoice_items di
173: where di.project_id = ey.project_id
174: and NVL(di.event_task_id,-1) = NVL(ey.task_id,-1)
175: and di.event_num = ey.event_num
176: and not exists (