APPS.INV_OPSM_LOT_BE_PKG SQL Statements

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

Line: 37

            SELECT COUNT(*)
              INTO L_NO_ENABLED_SUB
              FROM WF_EVENTS A
                  ,WF_EVENT_SUBSCRIPTIONS B
             WHERE A.GUID           = B.EVENT_FILTER_GUID
               AND A.NAME           = P_EVENT
               AND B.JAVA_RULE_FUNC ='oracle.apps.inv.opsm.lot.util.InvOpsmLotRule'
               AND B.STATUS         = 'ENABLED'
               AND B.SOURCE_TYPE    = 'LOCAL'
               AND B.SYSTEM_GUID    = HEXTORAW(WF_CORE.TRANSLATE('WF_SYSTEM_GUID')) ;