APPS.PA_IC_INV_UTILS dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 297: Update pa_summary_project_fundings

293: FROM pa_draft_invoice_items
294: WHERE draft_invoice_num = p_draft_invoice_num
295: AND project_id = p_project_id ;
296:
297: Update pa_summary_project_fundings
298: set total_accrued_amount = NVL(total_accrued_amount,0) +
299: decode(P_INVOICE_MODE,'DELETE',(-1)*l_total_billed_amount,
300: l_total_billed_amount),
301: total_billed_amount = NVL(total_billed_amount,0) +