APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_DUP_DETAILS

Line 469: UPDATE HZ_IMP_DUP_DETAILS idd

465: AND PARTY_ORIG_SYSTEM = idp.PARTY_OS
466: AND PARTY_ORIG_SYSTEM_REFERENCE BETWEEN l_dml_record.FROM_OSR AND l_dml_record.TO_OSR);
467:
468: -- update dup party site
469: UPDATE HZ_IMP_DUP_DETAILS idd
470: SET (PARTY_ID, RECORD_ID)=
471: ( SELECT PARTY_ID, PARTY_SITE_ID FROM HZ_IMP_ADDRESSES_SG ias
472: WHERE ias.PARTY_ORIG_SYSTEM = idd.PARTY_OS
473: and ias.PARTY_ORIG_SYSTEM_REFERENCE = idd.PARTY_OSR

Line 490: UPDATE HZ_IMP_DUP_DETAILS idd

486:
487:
488: -- update dup contact
489:
490: UPDATE HZ_IMP_DUP_DETAILS idd
491: SET (PARTY_ID, RECORD_ID)=
492: ( SELECT PARTY_ID, CONTACT_ID FROM HZ_IMP_CONTACTS_SG ics
493: WHERE ics.CONTACT_ORIG_SYSTEM = idd.RECORD_OS
494: and ics.CONTACT_ORIG_SYSTEM_REFERENCE = idd.RECORD_OSR

Line 509: UPDATE HZ_IMP_DUP_DETAILS idd

505:
506:
507: -- update dup contact point
508:
509: UPDATE HZ_IMP_DUP_DETAILS idd
510: SET (PARTY_ID, RECORD_ID)=
511: ( SELECT PARTY_ID, CONTACT_POINT_ID FROM HZ_IMP_CONTACTPTS_SG ics
512: WHERE ics.PARTY_ORIG_SYSTEM = idd.PARTY_OS
513: and ics.PARTY_ORIG_SYSTEM_REFERENCE = idd.PARTY_OSR