DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on IEX_DELINQUENCIES_ALL

Line 489: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id

485: if(regid_proc = true) then
486: insert into hz_application_trans_gt(app_id,party_id) select 695, temp.party_id from hz_purge_gt temp where
487:
488:
489: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id
490: )
491:
492: or exists (select 'Y' from HZ_PARTY_SITES
493: xx where xx.PARTY_ID = temp.party_id

Line 503: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id

499: else
500: delete from hz_purge_gt temp where
501:
502:
503: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id
504: )
505:
506: or exists (select 'Y' from HZ_PARTY_SITES
507: xx where xx.PARTY_ID = temp.party_id