Line 596: or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
592:
593: or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID = temp.party_id
594: )
595: 596: or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID = temp.party_id 597: );
598: else
599: delete from hz_purge_gt temp where
600:
Line 676: or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
672:
673: or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID = temp.party_id
674: )
675: 676: or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID = temp.party_id 677: );
678: end if;
679:
680: