APPS.HZ_PURGE_GEN dependencies on LNS_PARTICIPANTS

Line 1796: or exists (select 'Y' from LNS_PARTICIPANTS xx where xx.HZ_PARTY_ID = temp.party_id

1792:
1793: exists (select 'Y' from LNS_LOAN_HEADERS_ALL xx where xx.PRIMARY_BORROWER_ID = temp.party_id
1794: )
1795:
1796: or exists (select 'Y' from LNS_PARTICIPANTS xx where xx.HZ_PARTY_ID = temp.party_id
1797: );
1798: else
1799: delete from hz_purge_gt temp where
1800:

Line 1805: or exists (select 'Y' from LNS_PARTICIPANTS xx where xx.HZ_PARTY_ID = temp.party_id

1801:
1802: exists (select 'Y' from LNS_LOAN_HEADERS_ALL xx where xx.PRIMARY_BORROWER_ID = temp.party_id
1803: )
1804:
1805: or exists (select 'Y' from LNS_PARTICIPANTS xx where xx.HZ_PARTY_ID = temp.party_id
1806: );
1807: end if;
1808:
1809: