DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CONTACTPTS_SG

Line 572: INSERT INTO HZ_IMP_CONTACTPTS_SG

568: BEGIN
569:
570: if (P_RERUN = 'Y') then
571: -- re-run
572: INSERT INTO HZ_IMP_CONTACTPTS_SG
573: (
574: PARTY_ID,
575: PARTY_ORIG_SYSTEM,
576: PARTY_ORIG_SYSTEM_REFERENCE,

Line 683: INSERT INTO HZ_IMP_CONTACTPTS_SG

679: and hz_cpt_pri.status (+) = 'A'
680: );
681: else
682: -- first run
683: INSERT INTO HZ_IMP_CONTACTPTS_SG
684: (
685: PARTY_ID,
686: PARTY_ORIG_SYSTEM,
687: PARTY_ORIG_SYSTEM_REFERENCE,