APPS.AP_INVOICES_PKG dependencies on AP_INVOICE_LINES

Line 1877: FROM ap_invoice_lines

1873: BEGIN
1874:
1875: SELECT nvl(max(line_number),0)
1876: INTO l_max_line_number
1877: FROM ap_invoice_lines
1878: WHERE invoice_id = X_invoice_id;
1879:
1880: RETURN(l_max_line_number);
1881: END get_max_line_number;

Line 2553: -- and AP_INVOICE_LINES

2549:
2550: -----------------------------------------------------------------------
2551: -- Procedure insert_children
2552: -- Inserts child records into AP_HOLDS, AP_PAYMENT_SCHEDULES
2553: -- and AP_INVOICE_LINES
2554: -- PRECONDITION: Called from POST_INSERT
2555: -----------------------------------------------------------------------
2556:
2557: PROCEDURE insert_children (

Line 2821: from ap_invoice_lines_all

2817: SUM(decode(wfapproval_status,'REAPPROVE',1,0)) ,
2818: SUM(decode(wfapproval_status,'REJECTED',1,0)),
2819: SUM(decode(wfapproval_status,'INITIATED',1,0))
2820: into l_not_required,l_approved,l_reapprove,l_rejected, l_initiated
2821: from ap_invoice_lines_all
2822: where invoice_id=p_invoice_id
2823: and org_id=p_org_id;
2824: --group by wfapproval_status;
2825: