APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_CONTACTPTS_SG

Line 511: ( SELECT PARTY_ID, CONTACT_POINT_ID FROM HZ_IMP_CONTACTPTS_SG ics

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
514: and ics.BATCH_ID = P_BATCH_ID)
515: WHERE ENTITY = 'CONTACT_POINTS'

Line 520: FROM HZ_IMP_CONTACTPTS_SG

516: and idd.BATCH_ID = P_BATCH_ID
517: AND idd.PARTY_OS = l_dml_record.OS
518: AND idd.PARTY_OSR BETWEEN l_dml_record.FROM_OSR AND l_dml_record.TO_OSR
519: AND idd.PARTY_OSR IN (SELECT PARTY_ORIG_SYSTEM_REFERENCE
520: FROM HZ_IMP_CONTACTPTS_SG
521: WHERE BATCH_ID = P_BATCH_ID
522: AND PARTY_ORIG_SYSTEM = idd.PARTY_OS
523: AND PARTY_ORIG_SYSTEM_REFERENCE BETWEEN l_dml_record.FROM_OSR AND l_dml_record.TO_OSR);
524:

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

614: -- Analyze staging table after matching
615: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_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);