DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on AMS_PARTY_SOURCES

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

2214: if(regid_proc = true) then
2215: insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where
2216:
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: )

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

2265: else
2266: delete from hz_purge_gt temp where
2267:
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: )