APPS.MTH_PROCESS_TXN_PKG SQL Statements

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

Line: 87

            SELECT Count(*)
              INTO l_count
              FROM mth_plants_d mpd
             WHERE mpd.plant_pk_key = p_plant_pk_key;

Line: 101

            SELECT Count(*)
              INTO l_count
              FROM mth_equipments_d med
             WHERE med.equipment_pk_key = p_equipment_pk_key
               AND med.plant_fk_key = Nvl(p_plant_pk_key,med.plant_fk_key);

Line: 137

            SELECT from_date
              BULK COLLECT
              INTO l_from_date
              FROM mth_equip_statuses_stg
            FOR UPDATE OF from_date;

Line: 160

            SELECT reading_time
              BULK COLLECT
              INTO l_reading_time
              FROM mth_equip_output_stg
            FOR UPDATE OF reading_time;

Line: 224

                SELECT from_date
                  BULK COLLECT
                  INTO l_sts_fromdate
                  FROM mth_run_log
                 WHERE fact_table = 'MTH_EQUIP_STATUS_SUMMARY'
                FOR UPDATE OF from_date;

Line: 248

                SELECT from_date
                  BULK COLLECT
                  INTO l_sts_fromdate
                  FROM mth_run_log
                 WHERE fact_table = 'MTH_EQUIP_OUTPUT_SUMMARY'
                FOR UPDATE OF from_date;

Line: 527

           update run log set from date = sysdate, to date = null;