APPS.GMF_AP_INVOICE_PAYMENTS_INFO SQL Statements

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

Line: 8

    SELECT aip.invoice_id,
        aip.payment_num,
        aip.check_id,
        aip.invoice_payment_id,
        aip.amount,
        aip.last_update_date,
        aip.set_of_books_id,
        aip.posted_flag,
        aip.accounting_date,
        aip.period_name,
        ach.check_number,
        ach.check_date,
        ach.payment_method_lookup_code
    FROM   AP_INVOICE_PAYMENTS_ALL aip,
        AP_CHECKS_ALL ach
    WHERE aip.invoice_id   =  NVL(invoiceid,aip.invoice_id)
        AND aip.payment_num  =  NVL(paymentnum,aip.payment_num)
        AND  aip.invoice_payment_id=NVL(invoicepaymentid,aip.invoice_payment_id)
        AND aip.creation_date  BETWEEN
            nvl(startdate,aip.creation_date)  AND
            nvl(enddate,aip.creation_date)
        AND ach.check_id = aip.check_id;

Line: 38

                            lastupdatedate   out date,
                            setofbooksid   out number,
                            postedflag   out varchar2,
                            accountingdate   out date,
                            periodname   out varchar2,
                            checknumber     out number,
                            checkdate       out date,
                            paymentlookupcode out varchar2,
                            row_to_fetch in out number,
                            statuscode out number)  IS
  Begin
    IF NOT invoice_payments%ISOPEN THEN
      OPEN invoice_payments(  startdate,
                      enddate,
                      invoiceid,
                      paymentnum,
                      invoicepaymentid);

Line: 62

          lastupdatedate,
          setofbooksid,
          postedflag ,
          accountingdate,
          periodname,
          checknumber,
          checkdate,
          paymentlookupcode;