APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_DRAFT_INVOICES

Line 125: from pa_draft_invoices_all di,

121: UNION
122: select 'Invoice has outstanding balance ' , 'PA_ARPR_INV_AMT_DUE'
123: from dual
124: where exists ( select draft_invoice_num
125: from pa_draft_invoices_all di,
126: ar_payment_schedules ar
127: where di.project_id = p_project_id
128: and di.transfer_status_code = 'A'
129: and ar.customer_trx_id = di.system_reference

Line 136: from pa_draft_invoices_all di

132: UNION
133: select 'Invoice Not Transferred and Accepted ' , 'PA_ARPR_NOT_INV_IFCD'
134: from dual
135: where exists ( select draft_invoice_num
136: from pa_draft_invoices_all di
137: where di.project_id = p_project_id
138: and di.transfer_status_code <> 'A')
139: UNION
140: select 'UBR and UER not cleared' , 'PA_ARPR_NOT_UBR_UER'

Line 177: select NULL from pa_draft_invoices inv

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 (
177: select NULL from pa_draft_invoices inv
178: where inv.project_id = di.project_id
179: and inv.draft_invoice_num = di.draft_invoice_num
180: and inv.write_off_flag ='Y')
181: having sum(di.bill_trans_bill_amount) =