DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on UMX_REG_REQUESTS

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

2772:
2773: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2774: )
2775:
2776: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2777: and (ROWNUM < 2));
2778: else
2779: delete from hz_purge_gt temp where
2780:

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

2784:
2785: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2786: )
2787:
2788: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2789: and (ROWNUM < 2));
2790: end if;
2791:
2792: