APPS.INV_OPSM_LOT_BE_PKG dependencies on WF_EVENT_SUBSCRIPTIONS

Line 40: ,WF_EVENT_SUBSCRIPTIONS B

36: L_RAISE_EVENT := FALSE;
37: SELECT COUNT(*)
38: INTO L_NO_ENABLED_SUB
39: FROM WF_EVENTS A
40: ,WF_EVENT_SUBSCRIPTIONS B
41: WHERE A.GUID = B.EVENT_FILTER_GUID
42: AND A.NAME = P_EVENT
43: AND B.JAVA_RULE_FUNC ='oracle.apps.inv.opsm.lot.util.InvOpsmLotRule'
44: AND B.STATUS = 'ENABLED'