APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CONTACTROLES_SG

Line 2459: INSERT INTO HZ_IMP_CONTACTROLES_SG

2455: ) IS
2456:
2457: begin
2458: if(P_RERUN = 'Y') then
2459: INSERT INTO HZ_IMP_CONTACTROLES_SG
2460: (
2461: SUB_ORIG_SYSTEM,
2462: SUB_ORIG_SYSTEM_REFERENCE,
2463: CONTACT_ID,

Line 2528: INSERT INTO HZ_IMP_CONTACTROLES_SG

2524: where conr_w_cid.contact_id = hz_conr.org_contact_id (+)
2525: and conr_w_cid.role_type = hz_conr.role_type (+)
2526: );
2527: else
2528: INSERT INTO HZ_IMP_CONTACTROLES_SG
2529: (
2530: SUB_ORIG_SYSTEM,
2531: SUB_ORIG_SYSTEM_REFERENCE,
2532: CONTACT_ID,