APPS.PSA_SLA_PROCESSING_PKG SQL Statements

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

Line: 74

      UPDATE xla_ae_headers ae1
         SET funds_status_code = 'S'
       WHERE (ae1.event_id, ae1.application_id) IN
             (SELECT e.event_id,
                     e.application_id
                FROM xla_events_gt e,
                     gl_ledgers l
               WHERE e.application_id = p_application_id
                 AND e.process_status_code = 'P'
                 AND e.ledger_id = l.ledger_id
                 AND e.budgetary_control_flag = 'N'
                 AND l.enable_budgetary_control_flag = 'Y');

Line: 87

      psa_utils.debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );