DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on UMX_REG_REQUESTS

Line 2683: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id

2679:
2680: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2681: )
2682:
2683: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2684: and (ROWNUM < 2));
2685: else
2686: delete from hz_purge_gt temp where
2687:

Line 2695: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id

2691:
2692: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2693: )
2694:
2695: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2696: and (ROWNUM < 2));
2697: end if;
2698:
2699: