APPS.HZ_PURGE_GEN dependencies on CSC_CUSTOMERS

Line 2191: exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID = temp.party_id

2187: if(regid_proc = true) then
2188: insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where
2189:
2190:
2191: exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID = temp.party_id
2192: )
2193:
2194: or exists (select 'Y' from CSC_CUSTOMIZED_PLANS xx where xx.PARTY_ID = temp.party_id
2195: );

Line 2200: exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID = temp.party_id

2196: else
2197: delete from hz_purge_gt temp where
2198:
2199:
2200: exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID = temp.party_id
2201: )
2202:
2203: or exists (select 'Y' from CSC_CUSTOMIZED_PLANS xx where xx.PARTY_ID = temp.party_id
2204: );