APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 65: l_unmapped_value igs_he_code_map_val.map2%TYPE;

61: FROM igs_he_code_ass_val
62: WHERE association_code = cp_association_code
63: AND sequence = cp_sequence;
64:
65: l_unmapped_value igs_he_code_map_val.map2%TYPE;
66: l_assoc_type c_assoc_type%ROWTYPE;
67: l_where_stmt VARCHAR2(100);
68: l_stmt VARCHAR2(400);
69: l_affected_fields VARCHAR2(50);

Line 106: ' FROM igs_he_code_map_val ' ||

102: END IF;
103:
104: -- Construct where clause to get all OSS values which are not mapped
105: l_stmt := l_stmt || ' (SELECT map' || l_assoc.oss_seq ||
106: ' FROM igs_he_code_map_val ' ||
107: ' WHERE association_code = :ASS_CODE)';
108:
109: -- Include any other where conditions
110: IF l_assoc_type.association_type = 'CODE' THEN