APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CLASSIFICS_INT

Line 989: from hz_imp_classifics_int ca_int,

985: case when ca_int.class_category
986: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
987: then 'SIC' else ca_int.class_category end class_category,
988: ca_int.primary_flag
989: from hz_imp_classifics_int ca_int,
990: hz_imp_parties_sg party_sg,
991: hz_orig_sys_references mosr,
992: hz_imp_osr_change osr_ch_tbl
993: where ca_int.interface_status = 'C'

Line 1084: from hz_imp_classifics_int ca_int,

1080: case when ca_int.class_category
1081: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1082: then 'SIC' else ca_int.class_category end class_category,
1083: ca_int.primary_flag
1084: from hz_imp_classifics_int ca_int,
1085: hz_imp_parties_sg party_sg,
1086: hz_orig_sys_references mosr,
1087: hz_imp_osr_change osr_ch_tbl
1088: where ca_int.interface_status = 'C'

Line 1178: from hz_imp_classifics_int ca_int,

1174: case when ca_int.class_category
1175: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1176: then 'SIC' else ca_int.class_category end class_category,
1177: ca_int.primary_flag
1178: from hz_imp_classifics_int ca_int,
1179: hz_imp_parties_sg party_sg,
1180: hz_orig_sys_references mosr,
1181: hz_imp_osr_change osr_ch_tbl
1182: where ca_int.interface_status is null

Line 1273: from hz_imp_classifics_int ca_int,

1269: case when ca_int.class_category
1270: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1271: then 'SIC' else ca_int.class_category end class_category,
1272: ca_int.primary_flag
1273: from hz_imp_classifics_int ca_int,
1274: hz_imp_parties_sg party_sg,
1275: hz_orig_sys_references mosr,
1276: hz_imp_osr_change osr_ch_tbl
1277: where ca_int.interface_status is null