DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_BILLING dependencies on AR_PAYMENT_SCHEDULES

Line 126: ar_payment_schedules ar

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
130: and ( ar.amount_due_remaining is null