APPS.HZ_PURGE_GEN dependencies on IBW_SITE_VISITS

Line 2977: exists (select 'Y' from IBW_SITE_VISITS xx where xx.PARTY_ID = temp.party_id

2973: if(regid_proc = true) then
2974: insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp where
2975:
2976:
2977: exists (select 'Y' from IBW_SITE_VISITS xx where xx.PARTY_ID = temp.party_id
2978: );
2979: else
2980: delete from hz_purge_gt temp where
2981:

Line 2983: exists (select 'Y' from IBW_SITE_VISITS xx where xx.PARTY_ID = temp.party_id

2979: else
2980: delete from hz_purge_gt temp where
2981:
2982:
2983: exists (select 'Y' from IBW_SITE_VISITS xx where xx.PARTY_ID = temp.party_id
2984: );
2985: end if;
2986:
2987: