APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CONTACTS_SG

Line 2278: INSERT INTO HZ_IMP_CONTACTS_SG

2274: begin
2275:
2276: if(P_RERUN = 'Y') then
2277: -- re-run
2278: INSERT INTO HZ_IMP_CONTACTS_SG
2279: ( RELATIONSHIP_TYPE,
2280: RELATIONSHIP_CODE,
2281: START_DATE,
2282: END_DATE,

Line 2361: INSERT INTO HZ_IMP_CONTACTS_SG

2357: and cont_int.obj_orig_system_reference = obj_int.party_orig_system_reference (+)
2358: and cont_int.obj_orig_system = obj_int.party_orig_system (+)
2359: );
2360: else
2361: INSERT INTO HZ_IMP_CONTACTS_SG
2362: ( RELATIONSHIP_TYPE,
2363: RELATIONSHIP_CODE,
2364: START_DATE,
2365: END_DATE,

Line 2494: hz_imp_contacts_sg cont_sg,

2490: cont_sg.sub_id cont_sub_id,
2491: cont_sg.action_flag cont_action_flag,
2492: conrole_int.role_type role_type
2493: from hz_imp_contactroles_int conrole_int,
2494: hz_imp_contacts_sg cont_sg,
2495: hz_orig_sys_references con_mosr,
2496: hz_imp_parties_sg party_sg,
2497: hz_orig_sys_references party_mosr--,
2498: where conrole_int.batch_id = P_BATCH_ID

Line 2563: hz_imp_contacts_sg cont_sg,

2559: cont_sg.sub_id cont_sub_id,
2560: cont_sg.action_flag cont_action_flag,
2561: conrole_int.role_type role_type
2562: from hz_imp_contactroles_int conrole_int,
2563: hz_imp_contacts_sg cont_sg,
2564: hz_orig_sys_references con_mosr,
2565: hz_imp_parties_sg party_sg,
2566: hz_orig_sys_references party_mosr--,
2567: where conrole_int.batch_id = P_BATCH_ID