APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_RELSHIPS_INT

Line 1899: from hz_imp_RELSHIPS_int ri,

1895: ri.end_date end_date,
1896: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change, /* Bug 5383200 */
1897: sub_int.party_type sub_type,
1898: obj_int.party_type obj_type
1899: from hz_imp_RELSHIPS_int ri,
1900: hz_orig_sys_references mosr,
1901: hz_orig_sys_references mosr2,
1902: HZ_IMP_PARTIES_SG PARTY_SGA,
1903: HZ_IMP_PARTIES_SG PARTY_SGB,

Line 2009: from hz_imp_RELSHIPS_int ri,

2005: ri.end_date end_date,
2006: sub_int.party_type sub_type,
2007: obj_int.party_type obj_type,
2008: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change /* Bug 5383200 */
2009: from hz_imp_RELSHIPS_int ri,
2010: hz_orig_sys_references mosr,
2011: hz_orig_sys_references mosr2,
2012: HZ_IMP_PARTIES_SG PARTY_SGA,
2013: HZ_IMP_PARTIES_SG PARTY_SGB,

Line 2119: from hz_imp_RELSHIPS_int ri,

2115: ri.end_date end_date,
2116: sub_int.party_type sub_type,
2117: obj_int.party_type obj_type,
2118: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change /* Bug 5383200 */
2119: from hz_imp_RELSHIPS_int ri,
2120: hz_orig_sys_references mosr,
2121: hz_orig_sys_references mosr2,
2122: HZ_IMP_PARTIES_SG PARTY_SGA,
2123: HZ_IMP_PARTIES_SG PARTY_SGB,

Line 2228: from hz_imp_RELSHIPS_int ri,

2224: ri.end_date end_date,
2225: sub_int.party_type sub_type,
2226: obj_int.party_type obj_type,
2227: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change /* Bug 5383200 */
2228: from hz_imp_RELSHIPS_int ri,
2229: hz_orig_sys_references mosr,
2230: hz_orig_sys_references mosr2,
2231: HZ_IMP_PARTIES_SG PARTY_SGA,
2232: HZ_IMP_PARTIES_SG PARTY_SGB,