APPS.WF_PURGE dependencies on WF_ITEM_TYPES

Line 84: from WF_ITEM_TYPES WIT

80: and WI.END_DATE <= enddate
81: and WI.END_DATE > xenddate
82: and exists
83: (select null
84: from WF_ITEM_TYPES WIT
85: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
86: and WI.ITEM_TYPE = WIT.NAME
87: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
88: and not exists

Line 115: from WF_ITEM_TYPES WIT

111: and WI.ITEM_KEY = itemkey
112: and WI.end_date <= enddate
113: and exists
114: (select null
115: from WF_ITEM_TYPES WIT
116: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
117: and WI.ITEM_TYPE = WIT.NAME
118: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
119: and not exists

Line 157: from WF_ITEM_TYPES WIT

153: where WI.END_DATE <= enddate
154: and WI.END_DATE > xenddate
155: and exists
156: (select null
157: from WF_ITEM_TYPES WIT
158: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
159: and WI.ITEM_TYPE = WIT.NAME
160: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
161: and not exists

Line 623: from WF_ITEM_TYPES WIT

619: where WA.ITEM_TYPE = acttype
620: and WA.NAME = actname
621: and exists
622: (select null
623: from WF_ITEM_TYPES WIT
624: where WA.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
625: and WA.ITEM_TYPE = WIT.NAME
626: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type);
627:

Line 1032: from WF_ITEM_TYPES WIT

1028: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1029: and (
1030: exists(
1031: select null
1032: from WF_ITEM_TYPES WIT
1033: where WN.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0) <= enddate
1034: and WN.MESSAGE_TYPE = WIT.NAME
1035: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1036: or not exists(

Line 1038: from WF_ITEM_TYPES WIT

1034: and WN.MESSAGE_TYPE = WIT.NAME
1035: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1036: or not exists(
1037: select null
1038: from WF_ITEM_TYPES WIT
1039: where WN.MESSAGE_TYPE = WIT.NAME))
1040: and(
1041: (purgesigs = 1)
1042: or not exists

Line 1062: from WF_ITEM_TYPES WIT

1058: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1059: and (
1060: exists(
1061: select null
1062: from WF_ITEM_TYPES WIT
1063: where WN.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0) <= enddate
1064: and WN.MESSAGE_TYPE = WIT.NAME
1065: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1066: or not exists(

Line 1068: from WF_ITEM_TYPES WIT

1064: and WN.MESSAGE_TYPE = WIT.NAME
1065: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1066: or not exists(
1067: select null
1068: from WF_ITEM_TYPES WIT
1069: where WN.MESSAGE_TYPE = WIT.NAME))
1070: and(
1071: (purgesigs = 1)
1072: or not exists

Line 1646: from WF_ITEM_TYPES WIT

1642: where WI.ITEM_TYPE = p_itemType
1643: and WI.END_DATE <= sysdate
1644: and exists
1645: (select null
1646: from WF_ITEM_TYPES WIT
1647: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=sysdate
1648: and WI.ITEM_TYPE = WIT.NAME
1649: )
1650: and not exists