DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PROCESS dependencies on PA_DRAFT_INVOICE_DETAILS_ALL

Line 830: FROM pa_draft_invoice_details_all

826:
827: t_line_num :=0;
828:
829: SELECT max(line_num) INTO t_line_num
830: FROM pa_draft_invoice_details_all
831: WHERE expenditure_item_id = p_inv_rec.expenditure_item_id
832: AND draft_invoice_num IS NULL
833: AND DRAFT_INVOICE_LINE_NUM IS NULL
834: AND NVL(invoiced_flag,'N') ='N';