APPS.FV_AP_PREPAY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

       SELECT NVL(prepayment_tolerance_flag, 'N'), prepayment_tolerance
       INTO   l_prepay_tolerance_flag, l_prepay_tolerance
       FROM   fv_operating_units;

Line: 60

      SELECT DECODE(MATCHING_BASIS , 'AMOUNT' ,
      NVL(ll.amount,0)-nvl(ll.amount_cancelled,0),
     (NVL(ll.quantity,0) - NVL(ll.quantity_cancelled,0))* ll.price_override) total_amount,
      decode(matching_basis , 'AMOUNT' , NVL(ll.amount_financed,0) , NVL(ll.quantity_financed,0) * ll.price_override)  billed_amount
       INTO l_total_amount , l_billed_amount
      FROM po_line_locations_all  ll
      WHERE ll.line_location_id = p_line_location_id;

Line: 70

       SELECT (ll.quantity  - ll.quantity_cancelled) * l.unit_price total_amount,
              (ll.quantity_billed * l.unit_price) remain_amount
       INTO l_total_amount , l_billed_amount
       FROM po_line_locations_all ll,
	    po_lines_all l
       WHERE ll.line_location_id = p_line_location_id
       AND l.po_line_id = ll.po_line_id;