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: