APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_CONTACTS_SG

Line 492: ( SELECT PARTY_ID, CONTACT_ID FROM HZ_IMP_CONTACTS_SG ics

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
495: and ics.BATCH_ID = P_BATCH_ID)
496: WHERE ENTITY = 'CONTACTS'

Line 501: FROM HZ_IMP_CONTACTS_SG

497: and idd.BATCH_ID = P_BATCH_ID
498: AND idd.PARTY_OS = l_dml_record.OS
499: AND idd.PARTY_OSR BETWEEN l_dml_record.FROM_OSR AND l_dml_record.TO_OSR
500: AND idd.RECORD_OSR IN (SELECT CONTACT_ORIG_SYSTEM_REFERENCE
501: FROM HZ_IMP_CONTACTS_SG
502: WHERE BATCH_ID = P_BATCH_ID
503: AND CONTACT_ORIG_SYSTEM = idd.RECORD_OS
504: AND SUB_ORIG_SYSTEM_REFERENCE BETWEEN l_dml_record.FROM_OSR AND l_dml_record.TO_OSR);
505:

Line 620: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);

616: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
617: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
618: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
619: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
620: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
621: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
622: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
623: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
624: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);