DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on AMS_ACT_RESOURCES

Line 2260: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id

2256:
2257: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id
2258: )
2259:
2260: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2261: )
2262:
2263: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id
2264: );

Line 2311: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id

2307:
2308: or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID = temp.party_id
2309: )
2310:
2311: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2312: )
2313:
2314: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id
2315: );