APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_DUP_PARTIES

Line 453: UPDATE HZ_IMP_DUP_PARTIES idp

449:
450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'update dup party id ');
451:
452: -- update dup party id
453: UPDATE HZ_IMP_DUP_PARTIES idp
454: SET PARTY_ID =
455: ( SELECT PARTY_ID FROM HZ_IMP_PARTIES_SG ips
456: WHERE ips.PARTY_ORIG_SYSTEM = idp.PARTY_OS
457: and ips.PARTY_ORIG_SYSTEM_REFERENCE = idp.PARTY_OSR