328: and WIAS.NOTIFICATION_ID = WN.GROUP_ID
329: and ((purgesigs = 1)
330: or not exists
331: (select null
332: from WF_DIG_SIGS WDS
333: where SIG_OBJ_TYPE = 'WF_NTF'
334: and SIG_OBJ_ID = WN.NOTIFICATION_ID))
335: union all
336: select WN.NOTIFICATION_ID
341: and WIASH.NOTIFICATION_ID = WN.GROUP_ID
342: and ((purgesigs = 1)
343: or not exists
344: (select null
345: from WF_DIG_SIGS WDS
346: where SIG_OBJ_TYPE = 'WF_NTF'
347: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
348:
349: if (l_tempListTAB.COUNT > 0) then
1040: and(
1041: (purgesigs = 1)
1042: or not exists
1043: (select null
1044: from WF_DIG_SIGS WDS
1045: where SIG_OBJ_TYPE = 'WF_NTF'
1046: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
1047:
1048: cursor c2 is
1070: and(
1071: (purgesigs = 1)
1072: or not exists
1073: (select null
1074: from WF_DIG_SIGS WDS
1075: where SIG_OBJ_TYPE = 'WF_NTF'
1076: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
1077:
1078: --