APPS.HZ_PURGE_GEN dependencies on AMS_LIST_ENTRIES

Line 2120: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID = temp.party_id

2116:
2117: or exists (select 'Y' from AMS_IMP_SOURCE_LINES xx where xx.PARTY_ID = temp.party_id
2118: )
2119:
2120: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID = temp.party_id
2121: )
2122:
2123: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id
2124: )

Line 2123: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id

2119:
2120: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID = temp.party_id
2121: )
2122:
2123: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id
2124: )
2125:
2126: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2127: )

Line 2171: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID = temp.party_id

2167:
2168: or exists (select 'Y' from AMS_IMP_SOURCE_LINES xx where xx.PARTY_ID = temp.party_id
2169: )
2170:
2171: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID = temp.party_id
2172: )
2173:
2174: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id
2175: )

Line 2174: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id

2170:
2171: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID = temp.party_id
2172: )
2173:
2174: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id
2175: )
2176:
2177: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2178: )