DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_PWP_LINKED_INVOICES

Line 464: FROM pa_pwp_linked_invoices pwp

460: FROM (
461: SELECT ap_invoice_id Invoice_id
462: ,ei.project_currency_code proj_currency_code
463: ,SUM(ei.raw_cost) Invoice_Amount
464: FROM pa_pwp_linked_invoices pwp
465: ,pa_expenditure_items ei
466: WHERE pwp.ap_invoice_id = ei.document_header_id
467: AND pwp.project_id = ei.project_id
468: AND pwp.project_id = l_project_id