DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on IBY_ACCOUNT_OWNERS

Line 1690: exists (select 'Y' from IBY_ACCOUNT_OWNERS xx where xx.ACCOUNT_OWNER_PARTY_ID = temp.party_id

1686: if(regid_proc = true) then
1687: insert into hz_application_trans_gt(app_id,party_id) select 673, temp.party_id from hz_purge_gt temp where
1688:
1689:
1690: exists (select 'Y' from IBY_ACCOUNT_OWNERS xx where xx.ACCOUNT_OWNER_PARTY_ID = temp.party_id
1691: )
1692:
1693: or exists (select 'Y' from IBY_TRXN_SUMMARIES_ALL xx where xx.PAYERID = to_char(temp.party_id)
1694: )

Line 1705: exists (select 'Y' from IBY_ACCOUNT_OWNERS xx where xx.ACCOUNT_OWNER_PARTY_ID = temp.party_id

1701: else
1702: delete from hz_purge_gt temp where
1703:
1704:
1705: exists (select 'Y' from IBY_ACCOUNT_OWNERS xx where xx.ACCOUNT_OWNER_PARTY_ID = temp.party_id
1706: )
1707:
1708: or exists (select 'Y' from IBY_TRXN_SUMMARIES_ALL xx where xx.PAYERID = to_char(temp.party_id)
1709: )