APPS.GMF_AP_INVOICE_CHECKS_INFO SQL Statements

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

Line: 6

    SELECT   ach.amount,
          ach.bank_account_num,
          ach.bank_num,
          ach.bank_account_type,
          ach.currency_code,
          ach.status_lookup_code,
          ach.stopped_at,
          ach.released_at,
          ach.void_date
    FROM     AP_CHECKS_ALL ach
    WHERE     ach.check_id = NVL(checkid,ach.check_id)   AND
          ach.creation_date  BETWEEN
              nvl(startdate,ach.creation_date)  AND
              nvl(enddate,ach.creation_date);

Line: 21

/*    SELECT   aip.amount,
          aip.bank_account_num,
          aip.bank_num,
          aip.bank_account_type,
          ach.currency_code,
          ach.status_lookup_code
    FROM     AP_INVOICE_PAYMENTS_ALL aip,
          AP_CHECKS_ALL ach
    WHERE     aip.check_id = NVL(checkid,aip.check_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: 70

    select displayed_field into checkstatus
    from ap_lookup_codes
    where lookup_type = 'CHECK STATE'
    and   lookup_code = wcheck_status;

Line: 76

      select displayed_field into status
      from ap_lookup_codes
      where lookup_type = 'CHECK STATE'
      and   lookup_code = 'VOID';

Line: 83

      select displayed_field into status
      from ap_lookup_codes
      where lookup_type = 'STOP PAYMENT STATUS'
      and   lookup_code = 'STOPPED';

Line: 88

      select displayed_field into status
      from ap_lookup_codes
      where lookup_type = 'STOP PAYMENT STATUS'
      and   lookup_code = 'RELEASED';