APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CLASSIFICS_INT

Line 997: from hz_imp_classifics_int ca_int,

993: case when ca_int.class_category
994: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
995: then 'SIC' else ca_int.class_category end class_category,
996: ca_int.primary_flag
997: from hz_imp_classifics_int ca_int,
998: hz_imp_parties_sg party_sg,
999: hz_orig_sys_references mosr,
1000: hz_imp_osr_change osr_ch_tbl
1001: where ca_int.interface_status = 'C'

Line 1093: from hz_imp_classifics_int ca_int,

1089: case when ca_int.class_category
1090: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1091: then 'SIC' else ca_int.class_category end class_category,
1092: ca_int.primary_flag
1093: from hz_imp_classifics_int ca_int,
1094: hz_imp_parties_sg party_sg,
1095: hz_orig_sys_references mosr,
1096: hz_imp_osr_change osr_ch_tbl
1097: where ca_int.interface_status = 'C'

Line 1188: from hz_imp_classifics_int ca_int,

1184: case when ca_int.class_category
1185: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1186: then 'SIC' else ca_int.class_category end class_category,
1187: ca_int.primary_flag
1188: from hz_imp_classifics_int ca_int,
1189: hz_imp_parties_sg party_sg,
1190: hz_orig_sys_references mosr,
1191: hz_imp_osr_change osr_ch_tbl
1192: where ca_int.interface_status is null

Line 1284: from hz_imp_classifics_int ca_int,

1280: case when ca_int.class_category
1281: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1282: then 'SIC' else ca_int.class_category end class_category,
1283: ca_int.primary_flag
1284: from hz_imp_classifics_int ca_int,
1285: hz_imp_parties_sg party_sg,
1286: hz_orig_sys_references mosr,
1287: hz_imp_osr_change osr_ch_tbl
1288: where ca_int.interface_status is null