[Home] [Help]
1695:
1696: or exists (select 'Y' from IBY_CREDITCARD xx where xx.CARD_OWNER_ID = temp.party_id
1697: )
1698:
1699: or exists (select 'Y' from IBY_EXTERNAL_PAYERS_ALL xx where xx.PARTY_ID = temp.party_id
1700: );
1701: else
1702: delete from hz_purge_gt temp where
1703:
1710:
1711: or exists (select 'Y' from IBY_CREDITCARD xx where xx.CARD_OWNER_ID = temp.party_id
1712: )
1713:
1714: or exists (select 'Y' from IBY_EXTERNAL_PAYERS_ALL xx where xx.PARTY_ID = temp.party_id
1715: );
1716: end if;
1717:
1718: