APPS.HZ_PURGE_GEN dependencies on CSC_CUSTOMERS

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

2321: if(regid_proc = true) then
2322: insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where
2323:
2324:
2325: exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID = temp.party_id
2326: )
2327:
2328: or exists (select 'Y' from CSC_CUSTOMIZED_PLANS xx where xx.PARTY_ID = temp.party_id
2329: );

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

2330: else
2331: delete from hz_purge_gt temp where
2332:
2333:
2334: exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID = temp.party_id
2335: )
2336:
2337: or exists (select 'Y' from CSC_CUSTOMIZED_PLANS xx where xx.PARTY_ID = temp.party_id
2338: );