eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE_GEN dependencies on AMS_ACT_PARTNERS

Line 2221: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id

2217:
2218: exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID = temp.party_id
2219: )
2220:
2221: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id
2222: )
2223:
2224: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id
2225: )

Line 2224: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id

2220:
2221: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id
2222: )
2223:
2224: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id
2225: )
2226:
2227: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id
2228: )

Line 2227: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id

2223:
2224: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id
2225: )
2226:
2227: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id
2228: )
2229:
2230: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID = temp.party_id
2231: )

Line 2272: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id

2268:
2269: exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID = temp.party_id
2270: )
2271:
2272: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id
2273: )
2274:
2275: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id
2276: )

Line 2275: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id

2271:
2272: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id
2273: )
2274:
2275: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id
2276: )
2277:
2278: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id
2279: )

Line 2278: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id

2274:
2275: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID = temp.party_id
2276: )
2277:
2278: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id
2279: )
2280:
2281: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID = temp.party_id
2282: )