DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on AMS_PARTY_SOURCES

Line 2084: exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID = temp.party_id

2080: if(regid_proc = true) then
2081: insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where
2082:
2083:
2084: exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID = temp.party_id
2085: )
2086:
2087: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id
2088: )

Line 2135: exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID = temp.party_id

2131: else
2132: delete from hz_purge_gt temp where
2133:
2134:
2135: exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID = temp.party_id
2136: )
2137:
2138: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID = temp.party_id
2139: )