DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CONTACTPTS_SG

Line 574: INSERT INTO HZ_IMP_CONTACTPTS_SG

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

Line 687: INSERT INTO HZ_IMP_CONTACTPTS_SG

683: and hz_cpt_pri.status (+) = 'A'
684: );
685: else
686: -- first run
687: INSERT INTO HZ_IMP_CONTACTPTS_SG
688: (
689: PARTY_ID,
690: PARTY_ORIG_SYSTEM,
691: PARTY_ORIG_SYSTEM_REFERENCE,