DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on IEX_DELINQUENCIES_ALL

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

468: if(regid_proc = true) then
469: insert into hz_application_trans_gt(app_id,party_id) select 695, temp.party_id from hz_purge_gt temp where
470:
471:
472: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id
473: )
474:
475: or exists (select 'Y' from HZ_PARTY_SITES
476: xx where xx.PARTY_ID = temp.party_id

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

482: else
483: delete from hz_purge_gt temp where
484:
485:
486: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id
487: )
488:
489: or exists (select 'Y' from HZ_PARTY_SITES
490: xx where xx.PARTY_ID = temp.party_id