APPS.AP_PAYMENT_EVENT_PKG SQL Statements

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

Line: 21

     select ap_payment_event_s.nextval
     into   l_event_key
     from   sys.dual;

Line: 43

      l_parameter_list.DELETE;

Line: 59

   SELECT AC.check_id,
          AC.org_id
   FROM   ap_checks AC
   WHERE  AC.checkrun_name = p_checkrun_name
   AND    AC.ORG_ID = p_org_id
   AND    AC.completed_pmts_group_id = p_completed_pmts_group_id
   AND    AC.status_lookup_code NOT IN ('OVERFLOW','SET UP');