APPS.IGS_SV_UTIL dependencies on IGS_LOOKUP_VALUES

Line 169: FROM igs_lookup_values

165: FROM igs_sv_btch_summary
166: WHERE batch_id = p_batch_id
167: AND person_id = p_person_id
168: AND ACTION_CODE IN (SELECT lookup_code
169: FROM igs_lookup_values
170: WHERE lookup_type = cp_mutually_info_typ)
171: AND action_code <> 'NEW' AND TAG_CODE = cp_information_type;
172:
173: l_count NUMBER := 0;