APPS.AP_ISP_UTILITIES_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 2014: l_matching_basis po_line_locations_all.matching_basis%TYPE;

2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
2014: l_matching_basis po_line_locations_all.matching_basis%TYPE;
2015: l_overbill_flag VARCHAR2(2);
2016: l_curr_calling_sequence VARCHAR2(2000);
2017: l_debug_info VARCHAR2(2000);
2018: l_api_name VARCHAR2(50);

Line 2047: from po_line_locations_all

2043: decode(matching_basis, 'AMOUNT', amount_billed, quantity_billed)),
2044: matching_basis, quantity, amount
2045: into l_billed, l_matching_basis,
2046: l_quantity_ordered, l_amount_ordered
2047: from po_line_locations_all
2048: where line_location_id = l_po_line_location_id;
2049:
2050: if ( l_matching_basis = 'AMOUNT' ) then
2051: if ( l_amount + l_billed > l_amount_ordered ) then

Line 2331: FROM po_line_locations_all

2327: AND invoice_line_number = p_line_number;
2328:
2329: SELECT matching_basis
2330: INTO l_matching_basis
2331: FROM po_line_locations_all
2332: WHERE line_location_id = p_line_location_id;
2333:
2334: l_debug_info := 'Populate the pl/sql table with proration data';
2335: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN