DBA Data[Home] [Help]

APPS.PA_IC_INV_UTILS dependencies on PA_DRAFT_INVOICE_ITEMS

Line 202: Update pa_draft_invoice_items

198: last_update_login = l_user_id
199: where project_id = P_Project_Id
200: and draft_invoice_num = l_err_invoice_num;
201:
202: Update pa_draft_invoice_items
203: set draft_invoice_num = l_new_invoice_num,
204: last_update_date = SYSDATE,
205: last_update_login = l_user_id
206: where project_id = P_Project_Id

Line 293: FROM pa_draft_invoice_items

289: END IF;
290:
291: SELECT SUM(amount)
292: INTO l_total_billed_amount
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