APPS.UMX_REG_REQUESTS_PVT dependencies on WF_EVENTS

Line 22: from UMX_REG_SERVICES_B URS, WF_EVENTS WE

18:
19: select URS.REG_SERVICE_TYPE, URS.WF_ROLE_NAME, URS.AME_APPLICATION_ID,
20: URS.AME_TRANSACTION_TYPE_ID, URS.REG_FUNCTION_ID, WE.NAME,
21: URS.EMAIL_VERIFICATION_FLAG
22: from UMX_REG_SERVICES_B URS, WF_EVENTS WE
23: where URS.REG_SERVICE_CODE = X_REG_SERVICE_CODE
24: and nvl(URS.END_DATE, sysdate+1) > sysdate
25: and URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;
26:

Line 32: from UMX_REG_SERVICES_B URS, WF_EVENTS WE

28:
29: select URS.REG_SERVICE_TYPE, URS.REG_SERVICE_CODE, URS.AME_APPLICATION_ID,
30: URS.AME_TRANSACTION_TYPE_ID, URS.REG_FUNCTION_ID, WE.NAME,
31: URS.EMAIL_VERIFICATION_FLAG
32: from UMX_REG_SERVICES_B URS, WF_EVENTS WE
33: where URS.WF_ROLE_NAME = x_wf_role_name
34: and nvl(URS.END_DATE, sysdate+1) > sysdate
35: and URS.REG_SERVICE_TYPE = 'ADDITIONAL_ACCESS'
36: and URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;