APPS.WF_PURGE dependencies on WF_DIG_SIGS

Line 326: from WF_DIG_SIGS WDS

322: and WIAS.NOTIFICATION_ID = WN.GROUP_ID
323: and ((purgesigs = 1)
324: or not exists
325: (select null
326: from WF_DIG_SIGS WDS
327: where SIG_OBJ_TYPE = 'WF_NTF'
328: and SIG_OBJ_ID = WN.NOTIFICATION_ID))
329: union all
330: select WN.NOTIFICATION_ID

Line 339: from WF_DIG_SIGS WDS

335: and WIASH.NOTIFICATION_ID = WN.GROUP_ID
336: and ((purgesigs = 1)
337: or not exists
338: (select null
339: from WF_DIG_SIGS WDS
340: where SIG_OBJ_TYPE = 'WF_NTF'
341: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
342:
343: if (l_tempListTAB.COUNT > 0) then

Line 1057: from WF_DIG_SIGS WDS

1053: and(
1054: (purgesigs = 1)
1055: or not exists
1056: (select null
1057: from WF_DIG_SIGS WDS
1058: where SIG_OBJ_TYPE = 'WF_NTF'
1059: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
1060:
1061: cursor c2 is

Line 1087: from WF_DIG_SIGS WDS

1083: and(
1084: (purgesigs = 1)
1085: or not exists
1086: (select null
1087: from WF_DIG_SIGS WDS
1088: where SIG_OBJ_TYPE = 'WF_NTF'
1089: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
1090:
1091: --