APPS.IGS_AD_IMP_001 dependencies on IGS_LOOKUP_VALUES

Line 71: FROM igs_ad_imp_stats imp, igs_lookup_values lk

67: ***************************************************************/
68: CURSOR c_get_statistics (cp_lookup_type VARCHAR2,
69: cp_interface_run_id NUMBER) IS
70: SELECT total_rec_num, total_warn_num, total_success_num, total_error_num, meaning,entity_name
71: FROM igs_ad_imp_stats imp, igs_lookup_values lk
72: WHERE imp.src_cat_code = lk.lookup_code
73: AND lk.lookup_type = cp_lookup_type
74: AND imp.interface_run_id = cp_interface_run_id
75: ORDER BY meaning, entity_name;